Creating and Editing Tables


The following procedures describe how to create and edit database tables.

Creating a Table:

Right click where in the diagram you would like to add the table.

In the popup menu that appears, click Add Table.


Use the General tab to specify the table's name, comment and the schema it is to belong to.


Use the Column Templates tab to select the columns that are to be added automatically to this table.

Renaming a Table:

In the Database Explorer window, click on the Tables node in the node tree on the left of the window.

A grid of the tables will be shown in the lower right of the application window.

Rename the table by typing directly into this grid and hitting Enter.

Editing a Table:

In a Database Explorer window, expand the Tables node.

A grid of this schema's tables will be shown in the lower right of the Database Explorer window


Grid (Lower Right) for Editing Table Information

You can type directly into this grid to modify a table's name, comment or table options.

Deleting a Table:

In the Database Explorer window, click on the Tables node.

In the Tables grid in the lower right, select the rows representing the tables to delete. Click the Remove button.


See also:

Table Options
Column Templates
Renaming Tables and Columns