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

A primary key or index cannot have more than <Maximum> columns. (Visual Database Tools)

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.

For more information, see Creating Indexes (Database Engine).

Community Additions

© 2015 Microsoft