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
A copy of this was sent to Alain Kreienbuhl <akreienb_at_fisystem.fr>
(if that email address didn't require changing)
On Thu, 06 Jan 2000 13:07:12 +0100, you wrote:
>Hello,
>
>How do yo add a "check constraint" on a colomn of a existing table ?
>
>Thanks for your help.
>
>Alain.
>
>PS: Happy New Year
1* alter table emp add constraint empno_gt_zero check (empno > 0) tkyte_at_8i> /
Table altered.
--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 06 2000 - 06:54:37 CST