Working with Database Table Properties

Once you have created a Database Table, you can review its properties and check that the DBMS and Owner values are correct. To display the 'Properties' dialog for a Table, either double-click on the Table name in the 'Database Builder Tables' Package or on the Table element on a diagram.

Important

A DBMS must be assigned to a Table before you can add columns in it. If you are using the Database Builder then the DBMS of the data model will be automatically applied to all new Tables; however, if you have added a Table by other means (such as working on a diagram) then this is a manual step.

Tasks

Once the Database Table properties are defined, you are ready to add columns.

Task

See also

Set the database type for a Table - other than the Table name, the most important property to set for a Database Table is the database type.

Prior to creating a Physical Data Model it is advisable for you to set the default DBMS, which will be automatically applied to new database objects that you create outside of the Database Builder. You can set the default DBMS type in one of these ways: