New Index

The New Index dialog box in Server Explorer in Visual Studio lets you create a new index on a SQL Server Compact database.

Options

Displays the name of the table that the index will be created on.

Specify the name of the index that you want to create.

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.

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

Specify the sort direction of the selected index column, either Ascending or Descending.

Displays the data type information. If the table column is a computed column, Data type displays "computed column."

Displays the maximum number of bytes required to store the column data type.

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

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

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

Remove the selected column from participation in the index key.

Move the selected column up in the index key grid. For more information about column order in an index, see Query Performance Tuning (SQL Server Compact).

Move the selected column down in the index key grid.