Hello all,

I'm having an SQL <alt_col_clause> crisis. Trying to follow the
SQLRef for ALTER TABLE and can't seem to quite get the right syntax.
I want to convert a NULL field to be NOT NULL. I tried many things
most like:

ALTER TABLE myTable ALTER myField to type NOT NULL

and about 100 variations short of dropping and re-adding the field.

Is there any way to do this?

Cheers