Export (0) Print
Expand All

Indexes/Keys Dialog Box

Updated: March 12, 2009

Applies To: Windows Server 2008, Windows Server 2008 R2

Use the Indexes/Keys dialog box to specify which column in your table should be marked as a primary key or index.

 

Element Name Description

Add

Adds a primary key or index, and displays the properties for the key in the right pane.

Delete

Deletes the selected primary key or index. You will not receive a confirmation before the primary key or index is deleted.

Close

Closes the Indexes/Keys dialog box.

Columns

Select the column or columns to use for the primary key or index. For more information, see Index Columns Dialog Box.

Is Unique

Select True if the column enforces uniqueness on its values; otherwise, select False. If you select Primary Key for Type, Is Unique is set to True and becomes read-only.

Type

Select the type of key for the selected column from the drop-down list. You can select either Primary Key or Index. If you select Primary Key, Is Unique is set to True and becomes read-only, and you must also set Allow Nulls for the column to False.

(Name)

Type a name for the primary key or index. For example, if your column name is Username, you might type PK_Username.

Create as Clustered

Specify whether or not the index will be clustered. You can select either True or False. A clustered index stores indexed columns together to increase access speed. Microsoft SQL Server 2005 and Microsoft SQL Server 2008 allow only one clustered index per table, because the data rows themselves can only be sorted in one order. Generally, you should define a clustered index with as few columns as possible. For more information, see Clustered Index Design Guidelines.

Ignore Duplicate Keys

Specify whether or not to ignore duplicate keys. You can select either True or False.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft