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