zm.rar_oracle

Oracle、MySQLSQL、Server、DB2 UDB数据库获取表名的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 db2: SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='';