how to alter column size sysntax in SQL Server 2000 version

anand m

5y1.1k

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjay Kumar5y ago
You don’t write column keyword in alter statement. Remove keyword “column “ and it shall work!
Sachin Singh5y ago
use [] and the schema name, test below, change dbo to the schema name of yours.
USE [yourdatabaseName]
ALTER table [dbo].[PPAP_Approval]
ALTER column [CLID ] varchar(13);
Salman Beg5y ago
First thing is the column exists or not. Check this link for more, https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/