Physical Modeling › 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
- Click Tables on the Model menu.
The SQL Server Table Editor opens.
- 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.
- 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.
- 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
- (Optional) Click the Comment tab and enter any comments that you want to associate with the table.
- (Optional) Click the UDP tab to work with user-defined properties for the table.
- 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
