Error 1702

Troubleshooting SQL Server

Troubleshooting

Error 1702

Severity Level 16
Message Text

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

Explanation

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.

Action

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