Re: How to check and see table constraints?
From: Michael Hsiao <michael_at_infocomm.com.tw>
Date: 1997/10/13
Message-ID: <344172EF.F1589230_at_infocomm.com.tw>#1/1
Date: 1997/10/13
Message-ID: <344172EF.F1589230_at_infocomm.com.tw>#1/1
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
select * from user_constraints where table_name='table_name' ;
-- ยบ Michael HsiaoReceived on Mon Oct 13 1997 - 00:00:00 CEST