Dropping tables

You can drop a table from the Data Definition view.

To drop a table:

1. From the pop-up menu of the table, click Generate DDL to open the Generate SQL DDL wizard.

2. Provide the name and target location for the generated file. By default, the generated file is named after the currently selected data object, and placed in the same project.

3. Select the Generate SQL DDL with fully qualified names check box.

4. Select the Generate associated DROP statements check box to generate the DROP statement with the CREATE statement.

5. Ensure that the Open SQL DDL file for editing when done check box is cleared.

6. Click Finish to generate the file. The SQL DDL file appears under your project in the Data Definition view.

7. Right-click on the SQL DDL file, and click Run on Database Server to open the Run Script wizard.

8. Ensure that only the DROP TABLE statement for the table that you want to drop is selected. Clear all the selections for the unnecessary DROP TABLE statements and all the CREATE and ALTER statements.

9. Click Finish to drop the table from the Data Definition view.

 

Parent topic

Modifying database objects

 

Related tasks

Editing database objects
Renaming data objects
Copying or moving data objects
Deleting database objects