Only one clustered index can be created on table '<0s>'.

Message Text

Only one clustered index can be created on table '<0s>'.

Explanation

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore only one clustered index can be created on each table.

Action

To create a second index on the same table, change the Clustered property setting before creating the second index.

See Also
ALTER TABLE How to create an index using the Create Index Wizard (Enterprise Manager)
CREATE INDEX How to create an index when creating a table (Enterprise Manager)
CREATE TABLE Index Object
Creating SQL Server Indexes Indexes
  Modifying Column Properties
How to create a clustered index using a database diagram (Enterprise Manager) Table Indexes
How to create an index on an existing table (Enterprise Manager)  

 

  


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