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
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 - 11:22:34 CST