Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [SQL] add a check constraint to an existing column

Re: [SQL] add a check constraint to an existing column

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 6 Jan 2000 18:22:34 +0100
Message-ID: <852j13$1q39$1@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 - 11:22:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US