Error 1702

Severity Level 16

Message Text

Create table failed because column '%.*s' in table '%.*s' exceeds the maximum of 250 columns.

Explanation

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

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 250 or less. For details about creating tables, see the CREATE TABLE statement in the Microsoft SQL Server Transact-SQL Reference.