Select Columns (Statistics)

Use the Select Columns dialog box to add columns to the Statistics Columns grid on the New Statistics or Statistics Properties page. Columns may be selected in any order. Use the Move Up and Move Down buttons on the New Statistics or Statistics Properties page to change the order of columns for statistics.

The Columns grid displays information about the columns in the table. Check the column name to add the column. Information about the columns helps you select the correct column from the list. The information is read-only.

Options

  • Name
    Displays the name of the column described by the statistics. This can be a single column or a combination of columns in a single table.
  • Data Type
    Indicates the data type of the columns described by the statistics.
  • Size
    Displays the size of the data type for each column.
  • Identity
    Indicates an identity column when checked.
  • Allow NULLs
    Indicates whether the column accepts NULL values.

See Also

Other Resources

Index Statistics

Help and Information

Getting SQL Server 2005 Assistance