Share via


How to: Change Index Properties (Visual Database Tools)

Your index is automatically saved in the database when you save your table in Table Designer. The index is available for modification as soon as you create it.

To change index properties

  1. In Object Explorer, right-click the table you want to open 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.

  4. Change properties in the grid.

Your changes are saved to the database when you save the table.

Note

You can also manage indexes on some views.

See Also

Other Resources

Working with Indexes (Visual Database Tools)
Indexes/Keys Dialog Box (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance