Subject alter table syntax
Author skotaylor
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.