How can i get all the table names from a databse ?

[¹ùÑÇ·æ]

in my app, i need to fetch all the table names in a database ,which SQL
statements i can use ?

Thanks for any advices !

Albert Guo
Jiangsu ,China PRC
---------------------------------------------

[Arild Bakken]

For MSSQL:

select name from sysobjects where type = 'U'
or
select table_name from information_schema.tables where table_type = 'BASE
TABLE'

For other RDBMS - check their documentation.
Arild

"¹ùÑÇ·æ" <gr*************@yahoo.com> wrote in message
news:eN**************@tk2msftngp13.phx.gbl...

in my app, i need to fetch all the table names in a database ,which SQL
statements i can use ?

Thanks for any advices !

Albert Guo
Jiangsu ,China PRC
---------------------------------------------

[Greg Miller]

On Fri, 28 May 2004 08:42:24 +0200, "Arild Bakken"
<ar*****@hotmail.com> wrote:

For other RDBMS - check their documentation.

Oracle:
select table_name from all_tables;