Managing Tables
3.1. Importing tables using DDL
Here is a checklist for adding DDL upload functionality to AI2sql:
Verify your AI2SQL account privileges: Ensure that you have the necessary permissions to import DDL in your AI2SQL account. If you're unsure, check with AI2sql .
Prepare DDL code: Make sure your DDL code is well-formatted and error-free. Your DDL code should only contain CREATE statements for tables, without any INSERT, UPDATE, DELETE or other data manipulation statements. Test the DDL code in a local environment before attempting to import it into AI2SQL.
Navigate to the "Tables" section: Access the "Tables" section from the main menu of the AI2SQL platform.
Click the "Import DDL" button: Locate and click the "Import DDL scripts" button to open the DDL import dialog.
Paste the DDL code: Copy your DDL code with only the CREATE statements and paste it into the provided text area within the DDL import dialog.
Click "Save": Confirm the import process by clicking the "Save" button.
Review the imported tables: Carefully review the imported tables and their structures. Ensure that all tables, columns, and data types are correctly imported.
Make modifications if necessary: If you identify any issues or inaccuracies, make the necessary modifications to the imported tables.
Save changes: Save your changes and verify that the DDL import has been successfully completed.
Our SQL Table Creation Script Parser Tool only supports CREATE TABLE scripts. To ensure a smooth experience with the tool, please follow these guidelines:
Provide only 'CREATE TABLE' scripts
Enter only 'CREATE TABLE' scripts for parsing. Additional SQL commands are not supported. For example:
3.2. Manually adding tables
Navigate to the "Tables" section from the main menu.
Click the "Add Table" button to open the table creation dialog.
Enter the table name and columns.
Click "Save" to add the table to your AI2SQL account.
3.3. Editing, Updating, and Deleting Table Information
In the "Tables" section, locate the table you wish to edit, update, or delete.
Editing and Updating Table Information
Click the "Edit" button to open the table editing dialog.
Modify the table name, columns, or data types as needed.
Click "Save" to update the table information.
Deleting Table Information
Click the "Delete" button next to the table you wish to remove.
Confirm your decision by clicking "Yes" when prompted with a warning message about data loss.
Please note that deleting a table will permanently remove it and its data. Make sure you have a backup or are certain about this action before proceeding.
If you have any questions or need assistance, feel free to contact our support team at .
Here is a checklist for adding DDL upload functionality to AI2sql:
Verify your AI2SQL account privileges: Ensure that you have the necessary permissions to import DDL in your AI2SQL account. If you're unsure, check with AI2sql .
Prepare DDL code: Make sure your DDL code is well-formatted and error-free. Your DDL code should only contain CREATE statements for tables, without any INSERT, UPDATE, DELETE or other data manipulation statements. Test the DDL code in a local environment before attempting to import it into AI2SQL.
Navigate to the "Tables" section: Access the "Tables" section from the main menu of the AI2SQL platform.
Click the "Import DDL" button: Locate and click the "Import DDL scripts" button to open the DDL import dialog.
Paste the DDL code: Copy your DDL code with only the CREATE statements and paste it into the provided text area within the DDL import dialog.
Click "Save": Confirm the import process by clicking the "Save" button.
Review the imported tables: Carefully review the imported tables and their structures. Ensure that all tables, columns, and data types are correctly imported.
Make modifications if necessary: If you identify any issues or inaccuracies, make the necessary modifications to the imported tables.
Save changes: Save your changes and verify that the DDL import has been successfully completed.
Our SQL Table Creation Script Parser Tool only supports CREATE TABLE scripts. To ensure a smooth experience with the tool, please follow these guidelines:
Provide only 'CREATE TABLE' scripts
Enter only 'CREATE TABLE' scripts for parsing. Additional SQL commands are not supported. For example:
CREATE TABLE [dbo].[ADP_Registrations](
...
);3.2. Manually adding tables
Navigate to the "Tables" section from the main menu.
Click the "Add Table" button to open the table creation dialog.
Enter the table name and columns.
Click "Save" to add the table to your AI2SQL account.
3.3. Editing, Updating, and Deleting Table Information
In the "Tables" section, locate the table you wish to edit, update, or delete.
Editing and Updating Table Information
Click the "Edit" button to open the table editing dialog.
Modify the table name, columns, or data types as needed.
Click "Save" to update the table information.
Deleting Table Information
Click the "Delete" button next to the table you wish to remove.
Confirm your decision by clicking "Yes" when prompted with a warning message about data loss.
Please note that deleting a table will permanently remove it and its data. Make sure you have a backup or are certain about this action before proceeding.
If you have any questions or need assistance, feel free to contact our support team at .
Updated on: 15/06/2023
Thank you!