Re: How to check and see table constraints?

Cecil D'Souza wrote:
>
> Hi guys;
>
> I want to see the description of my tables with the constraints. How do I
> achieve this?.
> I have checked all the damn manuals and am stuck. Pl help.
>
> Thank you to Oracle for the fantastic documentation.
>
> Cecil

I think it will work for your -?

SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE FROM USER_CONSTRAINTS WHERE TABLE_NAME = 'EMP';

-- 
---------------------------------------------------------
Please welcome to my home -- http://www.flash.net/~sathya
                 
               ***** HAVE A NICE DAY *****