Alter column length in SQL

Question

ALTER TABLE tableName 
    MODIFY COLUMN columnName VARCHAR (256);

Error :

Incorrect syntax near 'VARCHAR'

Assuming SQL server, change the syntax to ALTER TABLE tableName ALTER COLUMN columnName VARCHAR (256); — Sparky, Aug 18 '22 at 16:01

score 0 · Accepted Answer · edited Aug 18 '22 at 16:35

0

The syntax for modifying a column definition is depending on used database. For Microsoft SQL Server for example, you would need to replace MODIFY COLUMN with ALTER COLUMN.

For better help you should specify your database type.

edited Aug 18 '22 at 16:35

marc_s

732,580
175
1,330
1,459

answered Aug 18 '22 at 16:02

lx78

64
3

Alter column length in SQL

1 Answers1