Re: how to see the complete description of table in oracle

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 18 Feb 2009 05:47:05 -0800 (PST)
Message-ID: <55fe80cc-8607-4bf4-8f46-4eb013711207_at_e3g2000vbe.googlegroups.com>

On Feb 18, 6:30 am, gazzag <gar..._at_jamms.org> wrote:
> On 18 Feb, 08:52, juned2..._at_gmail.com wrote:
>
> > hi,
> >  i want to see the complete description of table with it's structure
> > and constraints.
> > I also want to see the column name on which the constraints are
> > applied.
>
> So what have you tried so far?
>
> USER_CONSTRAINTS is one view that you could use.
>
> HTH
>
> -g

The dbms_metadata package as mentioned is one approach. Another is to use the individual Oracle rdbms dictionary views to look at the specific pieces of information desired at the moment.

dba_tables
dba_tab_columns            column info for table/view
dba_indexes
dba_ind_columns            columns in index
dba_constraints
dba_cons_columns         columns referenced by constraint
dba_ivews

etc ...

HTH -- Mark D Powell -- Received on Wed Feb 18 2009 - 07:47:05 CST