Tables Property Page
This property page contains a set of properties for the tables in your database.
Selected table
Shows the name of the selected table. If more than one table is selected in your 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 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.
This control is editable only if you are connected to a database as a user that is a member of the db_owner role or is a member of both the db_ddladmin and db_securityadmin roles.
Table name
Shows the name of the selected table. To rename the table, enter a new name in this box. For more information, see Renaming a Table.
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
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 File Group
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. 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, see Placing Tables on Filegroups.
Text File Group
Select the name of the file group you want to store the text and images from the selected table in. You must have at least one user-defined file group for this setting to be enabled. 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, see Placing Tables on Filegroups.
Description
You can enter any text in this field. The text that you enter is implemented as a SQL Server 2000 extended property.