A primary key or index cannot have more than <Maximum> columns. (Visual Database Tools)
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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).

Show:
© 2016 Microsoft