Modifying database objects

You can edit, rename, delete, and manipulate a database object. To modify database objects, you can use the Data Definition view or the Database Explorer view. Modifying database objects by using other text editors might damage them.

Editing database objects
You can edit database objects such as tables, columns, primary keys, and foreign keys.

Renaming data objects
You can rename databases, schemas, and tables.

Copying or moving data objects
You can copy or move data objects such as databases, schemas, tables, views, stored procedures, and user-defined functions in the Data perspective.

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.

Dropping tables
You can drop a table from the Data Definition view.