null -> not null or vice versa?

[cbielins]

I would like to alter a table's column from null to not null. Is this
possible or can you only do the reverse?

If I can do it, what's the syntax, the .pdf doesn't describe it.

TIA,
Chris

[Mark Yudkin]

You can't do anything in an alter statement that may invalidate any possible
existing SQL statement (let alone invalidate any existing content). In this
case, since the column permits a NULL, you cannot change it to no longer do
so. For the same reason, you can only add a new nullable column if it has a
default.

You will need to unload, drop, create and load the table. All of these
commands and SQL statements are documented.

<cb******@gmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

I would like to alter a table's column from null to not null. Is this
possible or can you only do the reverse?

If I can do it, what's the syntax, the .pdf doesn't describe it.

TIA,
Chris