How to: Modify an Index (SQL Server Management Studio)
This topic describes how to modify an index by using Object Explorer in SQL Server Management Studio.
 Important |
|---|
Indexes created as the result of a PRIMARY KEY or UNIQUE constraint cannot be modified by using this method. Instead, the constraint must be modified. |
To modify an index
-
In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
-
Expand Databases, expand the database in which the table belongs, and then expand Tables.
-
Expand the table in which the index belongs and then expand Indexes.
-
Right-click the index that you want to modify and then click Properties.
To modify index columns
-
To add, remove, or change the position of an index column, select the General page from the Index Properties dialog box.
