Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [SQL] add a check constraint to an existing column
Don't forget that under 8.1 you can choose to:
add it enabled but not validated
In the latter case you can then validate it later reporting exceptions to a table.
This allows you to add the constraint without locking the table from other users.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Michel Cadot wrote in message <852j13$1q39$1_at_news5.isdnet.net>...
>alter table <table> add constraint <constraint name>
>check (<condition for instance col between 1 and 10>);
>
>--
>Have a nice day
>Michel
>
>
>Alain Kreienbuhl <akreienb_at_fisystem.fr> a écrit dans le message :
>38748570.6E72345_at_fisystem.fr...
>> Hello,
>>
>> How do yo add a "check constraint" on a colomn of a existing table ?
>>
>> Thanks for your help.
>>
>> Alain.
>>
>> PS: Happy New Year
>>
>
>
Received on Thu Jan 06 2000 - 12:27:59 CST