Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Column <Columnname> in table <Tablename> participates in index <Indexname>. Columns with a datatype of <Datatypename> cannot participate in indexes or primary keys. (Visual Database Tools)

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. To change the datatype, first remove the index or primary key.

For more information see Creating Indexes (Database Engine), How to: Create Unique Indexes (Visual Database Tools), and How to: Create Primary Keys (Visual Database Tools).

Community Additions

© 2015 Microsoft