Export (0) Print
Expand All
Expand Minimize

Error 1702

SQL Server 2000

Error 1702

Severity Level 16
Message Text

CREATE TABLE failed because column '%.*ls' in table '%.*ls' exceeds the maximum of %d columns.


This error occurs when you try to create a table with more than 1,024 columns. The maximum number of definable columns per table is 1,024.

Column names must follow the rules for identifiers. They must be unique within a given table, but you can use the same column name in different tables in the same database.


Reduce the number of columns in the table to 1,024 or less. For more information about creating tables, see CREATE TABLE.

See Also

Errors 1000 - 1999

Maximum Capacity Specifications

Using Identifiers

© 2014 Microsoft