不同数据库中获得表名列表的SQL

  不同数据库中获得表名列表的SQL- -
                                      

Oracle

SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME
MySQL

SHOW TABLES
MS SQL Server

select name from sysobjects where type = N'U' order by name
DB2 UDB

SELECT NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T' AND CREATOR != 'SYSIBM' ORDER BY NAME