Deleting database objects
You can delete databases, schemas, and tables from the Data Definition view, and you can delete connections from the Database Explorer view. You can delete columns and constraints by editing the table that contains them. To delete a database object, use the Data Definition view or the Database Explorer view so that all dependent links are also removed.
To delete a database object:
- Select the data object that you want to delete.
- Either click Delete from that object's pop-up menu or press Delete.
When you delete a primary key (either by removing the constraint, its columns, or the table that defines it), any foreign key constraints that reference the key are also removed.
Parent topic
Modifying database objects
Related tasks
Editing database objects
Renaming data objects
Copying or moving data objects
Dropping tables