anand m

anand m

  • 1.8k
  • 168
  • 11.1k

how to alter column size sysntax in SQL Server 2000 version

Jun 25 2021 4:08 AM

Hello All,

WHen i am trying to change the column size in sql server 200 below steps

1. Right click on the table ->Design i am getting alert message has"

Saving definition changes to tables with large amounts of data could take a consider amount of time. while changes are being saved,
table data will not be accessible.".

2.  i tried using Alter syntax :

ALTER TABLE PPAP_Approval
ALTER column CLID varchar(13) 
I am getting below error mssg from SQL Server 2000 version.
Line 2: Incorrect syntax near 'column'.

Please correct me what is syntax to alter column size in SQL Server 2000 version.


Answers (3)