Re: how do I list tables in a database?

You can use the following Query

select table_name
from sys.dba_tables;

Brijesh

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-----
Received on Wed Jul 09 1997 - 00:00:00 CDT