How to modify an index (Enterprise Manager)

To modify an index

  1. Expand a server group; then expand a server.
  2. Expand Databases, expand the database in which the table belongs, and then click Tables.
  3. In the details pane, right-click the table, point to All Tasks, and then click Manage Indexes....
  4. In Existing indexes, click the name of the index to modify, and then click Edit....
  5. In Column, select the column you want to appear in the index. Composite indexes can be created by selecting more than one column.
  6. Optionally, select a column, and then click either Move Up or Move Down to change the order of the columns in the index.
  7. Optionally, in Index options, select:
  8. Optionally, click Edit SQL... to view and edit the Transact-SQL statement used to create the index.
See Also
Creating an Index Placing Indexes on Filegroups
How to create a clustered index using a database diagram Rebuilding an Index
How to create a unique index using a database diagram Viewing an Index
How to specify a fill factor for an index using a database diagram Renaming an Index

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.