By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

null -> not null or vice versa?

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.