Creating and Editing Tables


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

Creating a Table:

In the diagram panel of Database Explorer 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 new table's name, comment and the schema it is to be created in.


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


Use the Advanced tab to set the column sort order. Use Alphanumeric to sort columns alphabetically, and User Defined to allow columns to sorted as the user specifies.

Renaming a Table:

In a 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 Database Explorer window.

In this grid, rename the table by typing directly into this grid and hitting Enter.

Editing a Table:

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

Select the tree node representing the table to edit or click on the table in the diagram.

A grid of this database'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 a Database Explorer window, click on the Tables node in the node tree on the left of the window.

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


See also:

Table Options
Column Templates
Renaming Tables and Columns