How to: Show Index Properties (Visual Database Tools)

  • Article

You can display properties for an index in the Indexes/Keys dialog box.

To show index properties in the Properties window

  1. In Object Explorer, right-click the table for the index with properties you want to see and click Design (Modify in SP1 or earlier).

  2. From the Table Designer menu, click Indexes/Keys.

  3. Select the index from the Selected Primary/Unique Key or Index list.

    Properties are shown in the grid.

Note

You can also see an abbreviated list of index properties by selecting the index in Object Explorer. Properties are shown in the Properties window.

See Also

Other Resources

Working with Indexes (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance