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: