alter table / drop not null

[rmatthew]

I am attempting to execute the following:

 

alter table chronology alter column rec_tmstmp drop not null;

 

give the following:

 

incorrect syntax near the keywork not

 

Any ideas on the syntax to alter a column and make it nullable?

[Nerseus]

What database are you using?

In SQL Server, I'd use:

ALTER TABLE chronology ALTER COLUMN rec_tmstmp Timestamp NULL

 

The syntax is basically "ALTER COLUMN" and then just explain how you want the column to be, including the type and NULLability.

 

-ner