Add Check Constraint Error
I had encounter below error when I trying to add check constraint in my existing table. Any ideal to get rid of the error?
thanz in advance.
1 alter table table1 add contraint
2* chk_1 check (col1 in ('Y','N'))
chk_ 1 check (col1 in ('Y','N'))
ERROR at line 2:
ORA-02438: Column check constraint cannot reference other columns
Re: Add Check Constraint Error
Yes, that is the answer.
Originally posted by samc
Column check constraint cannot reference other columns
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
May be the column not part of the table or column name typed wrong.
SQL> create table kk ( no number(5));
SQL> alter table kk add constraint xcv check (no in(1,2));
Are you sure you really want check constraints? Personally I hate the damn things. Every time our developers add a new possible value to the code they then forget theres a check constrain and it sll stops working. Data-driven validation every time!
SQL> create table sjk (name varchar2(5));
SQL> alter table sjk add constraint cs check (name in ('Y','N'));
Click Here to Expand Forum to Full Width