table.hovertable {
\nfont-family: verdana,arial,sans-serif;
\nfont-size:11px;
\ncolor:#333333;
\nborder-width: 1px;
\nborder-color: #999999;
\nborder-collapse: collapse;
\n}
\ntable.hovertable th {
\nbackground-color:#c3dde0;
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}
\ntable.hovertable tr {
\nbackground-color:#d4e3e5;
\n}
\ntable.hovertable td {
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}<\/p>\n
What are the maximum number of Columns per index key in SQL Server?<\/b> <\/p>\n Now if you want to test the maximum number of columns limitation for index key,primary key you can use the below test script.<\/p>\n Test Script: When the script tries to create primary key with 17 columns you get below error:<\/p>\n
\nSQL Server supports a maximum of 16 Columns per index key .
\n
\nWhat are the maximum number of Columns per foreign key in SQL Server?<\/b>
\nSQL Server supports a maximum of 16 Columns per foreign key .
\n
\nWhat are the maximum number of Columns per primary key in SQL Server?<\/b>
\nSQL Server supports a maximum of 16 Columns per primary key .
\n<\/p>\n\n\n
\n Max Capacity For<\/th>\n SQL Server 2012<\/th>\n SQL Server 2008 R2<\/th>\n SQL Server 2008<\/th>\n SQL Server 2005<\/th>\n<\/tr>\n \n \nMaximum number of Columns per index key in SQL Server\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n<\/tr>\n \n \nMaximum number of Columns per Foreign key in SQL Server\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n<\/tr>\n \n \nMaximum number of Columns per Primary key in SQL Server\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n \n16 Columns\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n[sql]
\n–DROP TABLE TestMaximumColumnsPKTable
\nCREATE TABLE TestMaximumColumnsPKTable
\n(
\n COLUMN1 BIT NOT NULL,
\n COLUMN2 BIT NOT NULL,
\n COLUMN3 BIT NOT NULL,
\n COLUMN4 BIT NOT NULL,
\n COLUMN5 BIT NOT NULL,
\n COLUMN6 BIT NOT NULL,
\n COLUMN7 BIT NOT NULL,
\n COLUMN8 BIT NOT NULL,
\n COLUMN9 BIT NOT NULL,
\n COLUMN10 BIT NOT NULL,
\n COLUMN11 BIT NOT NULL,
\n COLUMN12 BIT NOT NULL,
\n COLUMN13 BIT NOT NULL,
\n COLUMN14 BIT NOT NULL,
\n COLUMN15 BIT NOT NULL,
\n COLUMN16 BIT NOT NULL,
\n COLUMN17 BIT NOT NULL PRIMARY KEY (COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5, COLUMN6, COLUMN7, COLUMN8, COLUMN9, COLUMN10, COLUMN11, COLUMN12, COLUMN13, COLUMN14, COLUMN15, COLUMN16, COLUMN17)
\n);
\n[\/sql]<\/p>\n
\nMsg 1904, Level 16, State 1, Line 1
\nThe index ” on table ‘TestMaximumColumnsPKTable’ has 17 column names in index key list. The maximum limit for index or statistics key column list is 16.
\nMsg 1750, Level 16, State 0, Line 1
\nCould not create constraint. See previous errors.
\n<\/font><\/p>\n