Modify Column

[charbrad]

I am trying to modify a column of datatype char(31) to varchar(3)

ALTER TABLE dbo.zyx_abcdef_hdr
MODIFY vc_xxx_zzz varchar(3)

I am getting error message:

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near vc_xxx_zzz'

Any suggestions?

 

[genomon]

Ummmmm - I think you need to use ALTER COLUMN, not MODIFY.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[charbrad]

thank you. To change from null to not null my syntax would be:

ALTER TABLE dbo.zyx_abcdef_hdr
ALTER COLUMN vc_xxx_zzz varchar(3) NOT NULL;

 

[JackVam]

charbrad , I think you're using MySQL syntax

Jack Vamvas

All the IT jobs in one place -

http://www.ITjobfeed.com