Tables Property Page

This property page contains a set of properties for the tables in your database.

Selected table

Shows the name of the table in Table Designer or the selected table in your database diagram. If more than one table is selected in your database diagram, only the name of the first table in your selection is visible. Expand the list to choose a different table whose properties you want to inspect or modify.

Owner

Shows the name of the table’s owner. The owner name is either a Microsoft SQL Server role or SQL Server user. The drop-down list contains all the users and roles defined in the database. Within the drop-down list, the users and roles have different icons; the role icon shows two faces, the user icon shows only one.

Table name

Shows the name of the selected table. To rename the table, enter a new name in this box. For more information, see Rename a Table in a Database Diagram.

Table Identity Column

Shows the column used by SQL Server as the table’s identity column. To change the identity column, choose from the drop-down list. Within the drop-down list, you can choose the blank entry to indicate that the table has no identity column.

Table ROWGUID Column

(SQL Server 7.0 or higher only.) Shows the column used by SQL Server as the table’s ROWGUID column. To change the ROWGUID column, choose from the drop-down list. Within the drop-down list, you can choose the blank entry to indicate that the table has no ROWGUID column.

Table Filegroup

Select the name of the file group in which you want to store the selected table data. You must have at least one user-defined file group for this setting to be enabled. This setting is only available for SQL Server 7.0 or higher databases. If you create a database object and do not specify its file group, SQL Server will assign it to the default file group. Initially, the default file group is the Primary file group.

For more information on creating and using file groups, see your SQL Server documentation.

Text Filegroup

Select the name of the file group in which you want to store the text and images from the selected table. You must have at least one user-defined file group for this setting to be enabled. This setting is only available for SQL Server 7.0 or higher databases. If you create a database object and do not specify its file group, SQL Server will assign it to the default file group. Initially, the default file group is Primary file group.

For more information on creating and using file groups, see your SQL Server documentation.

Description

You can enter any text in this field. The text that you enter is implemented as a SQL Server 2000 extended property. This field is available only when you are connected to a SQL Server 2000 database.