Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: viewing table
Arthur,
the information you want is located in different data dictionary views like:
dba_constraints dba_tables dba_indexes etc...
if you have a tool like PL/SQL Developer it would make life a whole lot easier.
Arthur <mechhunter_at_rocketmail.com> wrote in message
news:39c06d03.21914918_at_news.iinet.net.au...
> Hi all,
>
> This may be a silly question and all but,
> how do you look at the FULL nature of a table -
> what I mean is:
> it will show the contraints within the table,
> the allocated name,
> etc etc.
>
> Thanks -
> -Arthur
Received on Thu Sep 14 2000 - 05:13:25 CDT