1 out of 1 rated this helpful - Rate this topic

How to: Change Index Properties (Visual Database Tools)

SQL Server 2005

Updated: 12 December 2006

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

In Object Explorer, right-click the table you want to open and click Design (Modify in SP1 or earlier).
From the Table Designer menu, click Indexes/Keys.
Select the index from the Selected Primary/Unique Key or Index list.
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.

Other Resources

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

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD