DatabaseMetaData: getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
/*
Driver Loaded.
Got Connection.
SYSTEM_ALIASES
SYSTEM_ALLTYPEINFO
SYSTEM_AUTHORIZATIONS
SYSTEM_BESTROWIDENTIFIER
SYSTEM_CACHEINFO
SYSTEM_CATALOGS
SYSTEM_CHECK_COLUMN_USAGE
SYSTEM_CHECK_CONSTRAINTS
SYSTEM_CHECK_ROUTINE_USAGE
SYSTEM_CHECK_TABLE_USAGE
SYSTEM_CLASSPRIVILEGES
SYSTEM_COLLATIONS
SYSTEM_COLUMNPRIVILEGES
SYSTEM_COLUMNS
SYSTEM_CROSSREFERENCE
SYSTEM_INDEXINFO
SYSTEM_PRIMARYKEYS
SYSTEM_PROCEDURECOLUMNS
SYSTEM_PROCEDURES
SYSTEM_PROPERTIES
SYSTEM_ROLE_AUTHORIZATION_DESCRIPTORS
SYSTEM_SCHEMAS
SYSTEM_SCHEMATA
SYSTEM_SEQUENCES
SYSTEM_SESSIONINFO
SYSTEM_SESSIONS
SYSTEM_SUPERTABLES
SYSTEM_SUPERTYPES
SYSTEM_TABLEPRIVILEGES
SYSTEM_TABLES
SYSTEM_TABLETYPES
SYSTEM_TABLE_CONSTRAINTS
SYSTEM_TEXTTABLES
SYSTEM_TRIGGERCOLUMNS
SYSTEM_TRIGGERS
SYSTEM_TYPEINFO
SYSTEM_UDTATTRIBUTES
SYSTEM_UDTS
SYSTEM_USAGE_PRIVILEGES
SYSTEM_USERS
SYSTEM_VERSIONCOLUMNS
SYSTEM_VIEWS
SYSTEM_VIEW_COLUMN_USAGE
SYSTEM_VIEW_ROUTINE_USAGE
SYSTEM_VIEW_TABLE_USAGE
* */
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Main {
public static void main(String[] args) throws Exception {
DatabaseMetaData md = conn.getMetaData();
ResultSet rs = md.getTables(null, null, "%", null);
while (rs.next()) {
System.out.println(rs.getString(3));
} }
static Connection conn;
static Statement st;
static {
try {
// Step 1: Load the JDBC driver.
Class.forName("org.hsqldb.jdbcDriver");
System.out.println("Driver Loaded.");
// Step 2: Establish the connection to the database.
String url = "jdbc:hsqldb:data/tutorial";
conn = DriverManager.getConnection(url, "sa", "");
System.out.println("Got Connection.");
st = conn.createStatement();
} catch (Exception e) {
System.err.println("Got an exception! ");
e.printStackTrace();
System.exit(0);
}
}
}
JDBCListTables.zip( 596 k)Related examples in the same category
1. | DatabaseMetaData.columnNullable | | |
2. | DatabaseMetaData: getCatalogs() | | |
3. | DatabaseMetaData: getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | | |
4. | DatabaseMetaData: getDatabaseMajorVersion() | | |
5. | DatabaseMetaData: getDatabaseMinorVersion() | | |
6. | DatabaseMetaData: getDatabaseProductName() | | |
7. | DatabaseMetaData: getDatabaseProductVersion() | | |
8. | DatabaseMetaData: getDefaultTransactionIsolation() | | |
9. | DatabaseMetaData: getDriverName() | | |
10. | DatabaseMetaData: getDriverVersion() | | |
11. | DatabaseMetaData: getExportedKeys(String catalog, String schema, String table) | | |
12. | DatabaseMetaData: getImportedKeys(String catalog, String schema, String table) | | |
13. | DatabaseMetaData: getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) | | |
14. | DatabaseMetaData: getJDBCMajorVersion() | | |
15. | DatabaseMetaData: getJDBCMinorVersion() | | |
16. | DatabaseMetaData: getMaxCharLiteralLength() | | |
17. | DatabaseMetaData: getMaxRowSize() | | |
18. | DatabaseMetaData: getMaxStatementLength() | | |
19. | DatabaseMetaData: getMaxTablesInSelect() | | |
20. | DatabaseMetaData: getMaxTableNameLength() | | |
21. | DatabaseMetaData: getNumericFunctions() | | |
22. | DatabaseMetaData: getPrimaryKeys(String catalog, String schema, String table) | | |
23. | DatabaseMetaData: getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | | |
24. | DatabaseMetaData: getProcedureTerm() | | |
25. | DatabaseMetaData: getSchemas() | | |
26. | DatabaseMetaData: getSQLKeywords() | | |
27. | DatabaseMetaData: getStringFunctions() | | |
28. | DatabaseMetaData: getSystemFunctions() | | |
29. | DatabaseMetaData: getTableTypes() | | |
30. | DatabaseMetaData: getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | | |
31. | DatabaseMetaData: getTimeDateFunctions() | | |
32. | DatabaseMetaData: getTypeInfo() | | |
33. | DatabaseMetaData: getURL() | | |
34. | DatabaseMetaData: getUserName() | | |
35. | DatabaseMetaData: nullsAreSortedHigh() | | |
36. | DatabaseMetaData: supportsANSI92EntryLevelSQL() | | |
37. | DatabaseMetaData: supportsANSI92FullSQL() | | |
38. | DatabaseMetaData: supportsANSI92IntermediateSQL() | | |
39. | DatabaseMetaData: supportsBatchUpdates() | | |
40. | DatabaseMetaData: supportsCoreSQLGrammar() | | |
41. | DatabaseMetaData: supportsExtendedSQLGrammar() | | |
42. | DatabaseMetaData: supportsFullOuterJoins() | | |
43. | DatabaseMetaData: supportsMinimumSQLGrammar() | | |
44. | DatabaseMetaData: supportsMixedCaseQuotedIdentifiers() | | |
45. | DatabaseMetaData: supportsPositionedDelete() | | |
46. | DatabaseMetaData: supportsResultSetConcurrency(int type, int concurrency) | | |
47. | DatabaseMetaData: supportsResultSetHoldability(int holdability) | | |
48. | DatabaseMetaData: supportsResultSetType(int type) | | |
49. | DatabaseMetaData: supportsStatementPooling() | | |
50. | DatabaseMetaData: supportsTableCorrelationNames() | | |
51. | DatabaseMetaData: supportsTransactionIsolationLevel(int level) | | |
52. | DatabaseMetaData: supportsTransactions() | | |