Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to see constraints

VISHWAKARMAPARDEEPAug 10 2016 — edited Aug 11 2016

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

This post has been answered by JuanM on Aug 10 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2016
Added on Aug 10 2016
3 comments
996 views