Indexes/Keys Property Page
This property page contains a set of properties for the indexes, primary keys, and unique constraints attached to the tables in your database diagram. Indexes and constraints are not graphically represented in database diagrams.
Table name
Shows the name of the selected table in your diagram. If more than one table is selected in your diagram, only the name of the first table is visible.
Selected index
Shows the name of the first index for the selected table in your diagram. If more than one table is selected in your diagram, only the name of the first index for the first table is visible. To show properties for a different index, expand the drop-down list.
Type
Shows the index or key object type for the selected table: index, primary key, or unique.
New
Choose this button to create a new index, key, or unique constraint for the selected database table. For more information, see Creating an Index.
Delete
Choose this button to remove the selected index, key, or constraint from the table. For more information, see Deleting an Index.
Note If you try to delete a primary key that participates in relationships, a message appears asking you if you want to delete all the relationships, too. You cannot delete a primary key without first deleting the relationships it participates in.
Column name/Order
Shows the columns contributing to the index, primary key, or unique constraint, along with whether each column's values are arranged in ascending or descending order within the item. You can add, change, or remove column names in this list. You can also change the ascending/descending setting for each column.
Index name
Shows the name of the selected index. You can rename the index by entering a new name in this box. For more information, see Renaming an Index.
Index file group
Select the name of the file group in which you want to store the selected index. 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 on creating and using file groups, see Placing Indexes on Filegroups.
Create UNIQUE
Select this option to create a unique constraint or index for the selected database table. Specify whether you are creating a constraint or index by selecting either the Constraint or Index button.
- Ignore duplicate key If you create a unique index, you can set this option to ensure each value in an indexed column is unique.
Fill factor
Shows the fill factor that specifies how full each index page can be. If a fill factor is not specified, the database's default fill factor is used. For more information, see Specifying a Fill Factor for an Index.
Pad Index
If you specified a Fill Factor of more than zero percent, and you selected the option to create a unique index, you can tell SQL Server to use the same percentage you specified in Fill Factor as the space to leave open on each interior node. By default, SQL Server sets a two-row index size.
Create as CLUSTERED
Select this option to create a clustered index for the selected database table. For more information, see Creating a Clustered Index.
Don't automatically recompute statistics
Select this option to tell SQL Server to use previously created statistics. This choice may not produce optimal results and is not recommended.
For more information, see Statistical Information.