Managing table properties

Table Properties, list the table types and owners, you can add and edit aliases and comments.

To display the properties of a table, right-click on a table header in the panel on the Database Page and select Properties or double-click on the table header.

Viewing table types and owners

The Table Properties dialog displays the type of the table, for example Table, View, System Table and so on. You can also see if the table has an owner which is particularly relevant when using Oracle databases.

Note: You cannot change the settings for the table type or owner, only view them.

Adding and editing aliases and comments

Aliases and comments help you to remember what tables and fields are used for. For example, you could add an alias of Person to a table called T1 if you know that the table contains people's names and addresses.

You can see an alias in the tooltip for a table header.

To add aliases and comments, enter the required text into the Alias and Comment boxes as required.

Note: You can also add aliases and comments to fields in a similar manner.

Replacing original names with aliases

You can choose to display all of the table and field names as their aliases and you can toggle between using aliases and their original names. To do this, select Show Aliases from the View menu. When a check mark appears next to the Show Aliases command, all the table and field names will be displayed as their aliases. The tooltips will display the original table and field names.