Re: How to show the list of tables that I have access to.

In <41hui3$bsg_at_news1.cle.ab.com> Michael Pantaleano <mike.pantaleano_at_ab.com> writes:
>
>sli_at_runner (Sijian Li) wrote:
>>I am in the situation that I forget the name of tables I have
 created, how can
>>I get a list of the tables I have?
>
>You can do "select table_name from user_tables;", I'd also save that
 as a
>script named something like "tables.sql" then you can do "_at_tables"
 from sqlplus
>when ever you want to see that again. Since we have personal accounts
 and
>development accounts, and a whole development instance this becomes
 something I
>do daily.
>--

Hi,

    you can also try

    Select Object_Name
    from User_Objects
    Where Object_Type = 'TABLE';

    you can also use this select for index, sequence no etc.

Swapan Jha
jhas_at_ix.netcom.com Received on Fri Aug 25 1995 - 00:00:00 CEST