Column '<1s>' in table '<0s>' participates in index '<2s>'. Columns with a datatype of '<3s>' cannot participate in indexes or primary keys.

Message Text

Column '<1s>' in table '<0s>' participates in index '<2s>'. Columns with a datatype of '<3s>' cannot participate in indexes or primary keys.

Explanation

You have attempted to change the datatype of a column that is part of an index or a primary key. Indexes and primary keys cannot be created for columns with datatypes such as TEXT or IMAGE.

Action

To change the datatype, first remove the index or 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) UNIQUE Constraints

  


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