Re: how do I list tables in a database?

Lane W. Sharman wrote:
>
> select * from user_tables;

Dick Allie wrote:

This only gets the tables owned by that user that is logged into sql. login as system and select * from dba_tables. Or as a user logged in select * from all_tables will list all tables you have access to.
Dick Allie
>
> -L
>
> Paul Mahler wrote:
>
> > Can someone please tell me how I can use SQL, or some other tool, to
> > list all the tables in a database?
> >
> > Thanks in advance,
> >
> > --
> > Paul Mahler
> > Data Based Systems, Inc.
> > email: pmahler_at_databased.com
> >
> > -----BEGIN PGP PUBLIC KEY BLOCK-----
> > Version: 2.6.2
> >
> > mQCNAzN/SC8AAAEEAMCuCCh/91S1tpCnuVKPprNfs1UACh9bMfDCJ6qmzjM9RA0b
> > 4qUX/7QC8a8f/7weRYKdwBuejx2mJuOzy32LDuwnyFU3hexTBplotAS67M4JOnV2
> > YwO/OJGzW5rA8RTYIGx75c7fmG7gCJbWBIx2YbWlJaTZlGoUGZ14WfWZVswhAAUT
> > tCZQYXVsIFMuIE1haGxlciA8cG1haGxlckBkYXRhYmFzZWQuY29tPg==
> > =ei0y
> > -----END PGP PUBLIC KEY BLOCK-----
>
> --
> Lane Sharman
> Pour chasser le chagrin,
> il faut du vin.
  Received on Tue Jul 01 1997 - 00:00:00 CDT