SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

Error Received:

Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

SQL Server 2000 supports table with maximum 1024 columns. This errors happens when we try to create table with 1024 columns or try to add columns to table which exceeds more than 1024.

Fix/Solution/WorkAround:
Reduce the number of columns in the table to 1,024 or less.

Reference : Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
Next Post
SQL SERVER – 2005 – Disable Triggers – Drop Triggers

Related Posts

3 Comments. Leave new

  • But the columns in the table are 10 they are not even close to 1024……

    Can you reply ASAP

    Charles

    Reply
  • Charles,

    I have been plauged by this issue as well, my table only had 3 columns and when the Alter statement came up, I was getting the exceeds the maximum columns (sql 2K). The alter statement is in a stored proc that gets run by the app frequently. The proc drops the column before it exits, but still…

    It was hair raising…

    The fix was to script the table, then drop it, and then recreate the table. In my case the table did not have any data in it, so I didn’t have to worry about repopulating it once it was recreated.

    Hope that helps,
    Mark

    Reply
  • this is not the solution. what if table contains lots of data and my table has just 60 columns. please provide proper solution.

    Reply

Leave a Reply