Re: Not Null Column in a existing table....

Marty Grinstead <MGrinstead_at_email.msn.com> wrote in article <OrQmzh3F$GA.234_at_cpmsnbbsa05>...
: The only way I can think of would be to add the column, then add the data,
: then add the constraint as a table constraint. There is probably other
: ways, but this seems straight forward... And what about using alter table add with  .. default <Your_default_value> not null ?
: Pankaj Joshi wrote in message <7u9oth$6h3$1_at_news.vsnl.net.in>...
: >Can anyone guide me.....how to add a column with not null constraint
in a
: >populated table without affecting the data.

-- 
 Alexander I.Doroshko, aid_at_grant.kharkov.ua
 * Bank "Grant", Kharkov, Ukraine