Index Properties (SQL Server Compact)

These properties appear in the Properties window when you select an index in Table Designer in SQL Server Management Studio, SQL Server Management Studio Express, or Server Explorer in Visual Studio.

Options

Table name

Displays the name of the table that the index is created on.

Index name

Displays the name of the index. If you create an index, specify the index name here.

Unique

Selecting this check box makes the index unique. No two rows are permitted to have the same index value. By default, this option is cleared.

Enforces primary key constraint

Indicates if the index has been created by the SQL Server Compact 3.5 Database Engine to enforce a primary key constraint. You cannot modify this check box. Therefore, the check box is dimmed. Use the Create Table and Edit Table dialog boxes to define columns that should be part of the primary key for the table that the index refers to.

Index Key Columns Name

Displays the name of the column that participates in the index key.

Sort Order

Specify the sort direction of the index key values for the column, either Ascending or Descending.

Data Type

Displays the data type information for the column.

Size

Displays the maximum number of bytes required to store the index key value for the column.

Identity

Displays whether the column participating in the index key is an identity column.

Allows Nulls

Displays whether the column participating in the index key permits NULL values to be stored in the table or view column.

Add

Add a column to the index key. Select table columns from the Select Columns dialog box that appears when you click Add.

Remove

Remove the selected column from participation in the index key.

Move Up

Move the selected column up in the index key grid.

Note

The order of the columns in index key corresponds to the order in the grid.

Move Down

Move the selected column down in the index key grid.