通过数据库系统表获得:
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
JAVA中使用JDBC获取数据库源数据的方法:
DatabaseMetaData dbmd = conn.getMetaData(); //通过数据连接获取数据库源数据
ResultSet rs = dbmd.getTableTypes();
String[] types = { "TABLE" };
rs = dbmd.getTables(null, dbmd.getUserName(), "%", types);//获取所有的用户表