Physical Modeling › SQL Server Physical Property Editors › SQL Server Model Objects › Define SQL Server Tables

Define SQL Server Tables

Use the SQL Server Table Editor to define the tables in a database in a SQL Server 2005/2008 physical model.

To define a SQL Server table

1. Click Tables on the Model menu.

   The SQL Server Table Editor opens.

2. Select the table in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new table.

   • Physical Name

     Specifies the physical name of the table. Change the physical name of the table in this field.

   • Schema

     Specifies the schema of the database to which the table belongs. Select the schema from the drop-down list.

   • Physical Only

     Specifies whether the table is suppressed from a logical model and appear in a physical model only.

   • Generate

     Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following options:
   • File Group

     Specifies the file group for the table. Select a file group from the drop-down list.

   • Text Image

     Specifies the text image for the table. Select a text image from the drop-down list.

   • Row Count

     Defines row count for the table. Enter a value in the field.

   • Max Row

     Defines row sizing for the table. Enter a value in the field.

   • Grow By

     Defines growth increments for the table. Enter a value in the field.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Define partition columns in the Partitions tab
   • Specify validation rules in the Validation tab
   • Define table permissions using the Permission tab
   • Specify the order of DDL generation in the Object Creation Order tab
   • View the history of events for the table using the History tab
5. (Optional) Click the Comment tab and enter any comments that you want to associate with the table.
6. (Optional) Click the UDP tab to work with user-defined properties for the table.
7. Click Close.

   The table is defined and the SQL Server Table Editor closes.