各种数据库获取表名的SQL语句

bbisky

OracleSELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAMEMySQLSHOW TABLESMS SQL Serverselect name from sysobjects where type = N’U’ order by nameDB2 UDBSELECT NAME FROM SYSIBM.SYSTABLES WHERE TYPE = ‘T’ AND CREATOR != ‘SYSIBM’ ORDER BY NAME