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

Sijian Li (sli_at_runner) wrote:

> Hi Folks,
 

> 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?

select * from tabs; /* your tables */

select * from all_tables; /* tables that you have access to */

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************