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

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...

Pankaj Joshi wrote in message <7u9oth$6h3$1_at_news.vsnl.net.in>...
>Hi Folks,
>Can anyone guide me.....how to add a column with not null constraint in a
>populated table without affecting the data.
>
>Thanks in advance,
>
>Pankaj
>
>
Received on Sat Oct 16 1999 - 03:27:20 CEST