获得数据库中表名列表

上一篇 / 下一篇 2008-07-15 14:55:07 / 个人分类：软件测试基础

获得数据库中表名列表：

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