Index Properties (Included Columns Page)

Use this page to modify the set of columns that are included as nonkey columns in a nonclustered index.

Options

  • 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.

    Note

    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.