Re: how to see the complete description of table in oracle
Date: Wed, 18 Feb 2009 05:47:05 -0800 (PST)
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.
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
HTH -- Mark D Powell -- Received on Wed Feb 18 2009 - 07:47:05 CST