Dear experts,
I want to see table constraint information from sql plus. Is it possible to see.
SQL>desc test --is showing only Not Null information
e.g.
SQL>create table test(cunique number(2,0) constraint c_unique unique,ccheck number(3,0) constraint ccheck check(ccheck between 500 and 999));
SQL> desc test;
Name Null? Type
----------------------------------------- -------- ----------------------------
CUNIQUE NUMBER(2)
CCHECK NUMBER(3)
I want to see all the constraints (like check - 500 and 999))) applied on table.
regards,
Pardeep