A primary key or index cannot have more than <0d> columns.

Message Text

A primary key or index cannot have more than <0d> columns.

Explanation

Microsoft® SQL Server™ does not allow more than 16 columns in an index. Because a primary key has an associated index, there can be no more than 16 columns in a primary key.

See Also
ALTER TABLE How to create an index when creating a table (Enterprise Manager)
CREATE INDEX Index Object
CREATE TABLE Indexes
Creating and Modifying PRIMARY KEY Constraints InPrimaryKey Property
Creating SQL Server Indexes Modifying Column Properties
HasPrimaryKey Property SQLPrimaryKeys
How to create an index on an existing table (Enterprise Manager) Table Indexes
How to create an index using the Create Index Wizard (Enterprise Manager)  

 

  


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