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

Primary key or index cannot be created on column <Columnname> because its data type is <Datatypename>. (Visual Database Tools)

You have included in an index or primary key a column whose data type precludes its participation in keys or indexes. Change the column's data type or remove it from the index or primary key.

For the rules restricting the data types of index and key columns, see Creating Indexes (Database Engine).

Community Additions

© 2015 Microsoft