Re: how to see the complete description of table in oracle
From: gazzag <gareth_at_jamms.org>
Date: Wed, 18 Feb 2009 03:30:08 -0800 (PST)
Message-ID: <88ed7b8f-a68f-4dab-b918-4f1d48145323_at_v13g2000yqm.googlegroups.com>
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.
Date: Wed, 18 Feb 2009 03:30:08 -0800 (PST)
Message-ID: <88ed7b8f-a68f-4dab-b918-4f1d48145323_at_v13g2000yqm.googlegroups.com>
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 Received on Wed Feb 18 2009 - 05:30:08 CST