A primary key or index cannot be created on columns with a datatype of <0s>.

Message Text

A primary key or index cannot be created on columns with a datatype of <0s>.

Explanation

A column’s datatype defines what kind of information can be stored in a column. Some datatypes such as TEXT or Image cannot be used in an index because servers will not allow indexes on these types of data.

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.