Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2005 Property Editors › Define a Table in SQL Server 2005

Define a Table in SQL Server 2005

In a model based on a SQL Server 2005 target server, you use the SQL Server Table Editor to define the properties for a table.

To define a table in SQL Server 2005

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. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

   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:

   Filegroup

   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.

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
   • Define table volumetrics in the Volumetrics tab
   • Work with style sheets to format the font used in the display of the table in the Style tab
   • Specify the entity icon to use in the Icon tab
   • Specify the order of DDL generation in the Object Creation Order tab
   • View where the table is used in the model in the Where Used tab
   • View the history of events for the table and add or view user notes using the Notes 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.

More information:

Define a Partition for a SQL Server Table

Define Validation Rule Usage for a SQL Server Table

Define Permissions for an Object in a SQL Server Property Editor

View History in a Property Editor

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor

Define a Dimensional Modeling Role in a Property Editor

Define Data Movement Rules in a Property Editor