Subject | alter table syntax |
---|---|
Author | skotaylor |
Post date | 2003-06-27T15:18:59Z |
Hello all,
I'm want to alter a column from 'NOT NULL' to 'NULL', it doesn't need
to be 'NOT NULL' it's not part of any constraints. I'm having a hard
time with the syntax, or is it even possible?
I've tried many things, ie:
alter table stmenu
alter column name varchar(40) null
but keep getting:
Token unknown - line 2, char 21
varchar
the SQL ref is not helping me much here, it's not clear if I can even
do this, but I hate to loose all the data.
Thanks for any hints.
Scott.
I'm want to alter a column from 'NOT NULL' to 'NULL', it doesn't need
to be 'NOT NULL' it's not part of any constraints. I'm having a hard
time with the syntax, or is it even possible?
I've tried many things, ie:
alter table stmenu
alter column name varchar(40) null
but keep getting:
Token unknown - line 2, char 21
varchar
the SQL ref is not helping me much here, it's not clear if I can even
do this, but I hate to loose all the data.
Thanks for any hints.
Scott.