Export (0) Print
Expand All

Index Properties (Included Columns Page)

Use this page to modify the set of columns that are included as nonkey columns in a nonclustered index. This page is only available for Microsoft SQL Server 2005 indexes.

Nonkey columns to include in the index

Include nonkey columns in the nonclustered index. This option allows you to bypass the current index limits on the total size of an index key and the maximum number of columns participating in an index key by adding columns as nonkey columns in the leaf level of the nonclustered index.

Name

Displays the name of the included column.

Data Type

Displays the data type information. All data types are allowed except text, ntext, and image.

ms178671.note(en-US,SQL.90).gifNote:
If the table column is a computed column, Data Type displays "computed column."

Size

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

Identity

Displays whether the included column is an identity column.

Allow NULLs

Displays whether the included column allows NULL values to be stored in the table or view column.

Add

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

Remove

Removes the selected row from the list of included columns.

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

Community Additions

ADD
Show:
© 2014 Microsoft