Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to check constraints on Table - DISPLAY

Re: How to check constraints on Table - DISPLAY

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: 1997/10/12
Message-ID: <Pine.OSF.3.95.971012005320.24862C-100000@gonzo.wolfenet.com>#1/1

On 12 Oct 1997, Cecil D'Souza wrote:
>
> I want to see the description of my tabels with the constraints. How do
> I achieve this. I have checked all the damn manuals and am stuck. Pl
> help.

select * from dba_cons_columns where table_name = '&table';

--
Jeremiah Wilton      http://www.wolfenet.com/~jeremiah
Received on Sun Oct 12 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US