3.1. Importing tables using DDL

Here is a checklist for adding DDL upload functionality to AI2sql:

1. 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 support.

2. 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.

3. Navigate to the "Tables" section: Access the "Tables" section from the main menu of the AI2SQL platform.

4. Click the "Import DDL" button: Locate and click the "Import DDL scripts" button to open the DDL import dialog.

5. 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.

6. Click "Save": Confirm the import process by clicking the "Save" button.

7. Review the imported tables: Carefully review the imported tables and their structures. Ensure that all tables, columns, and data types are correctly imported.

8. Make modifications if necessary: If you identify any issues or inaccuracies, make the necessary modifications to the imported tables.

9. Save changes: Save your changes and verify that the DDL import has been successfully completed.

10. 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](
    ...
);