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

 

[Greg Miller]

For other RDBMS - check their documentation.

Oracle:
select table_name from all_tables;