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

Saad Ahmad (sahmad_at_mfa.com) wrote:
: 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 */

Or, user_tables (user_views, user_indexes, etc.)

: 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 *
: **************************************************************

--
                                   
=------------------------------------------------------------------------=
Joe Nardone               |    
joe_at_access.digex.net      |