DEVFYI - Developer Resource - FYI

How do I check what table types exist in a database?

JDBC Interview Questions and Answers

(Continued from previous question...)

How do I check what table types exist in a database?

Use the getTableTypes method of interface java.sql.DatabaseMetaData to probe the database for table types. The exact usage is described in the code below.

public static void main(String[] args) throws Exception
{
// Load the database driver - in this case, we
// use the Jdbc/Odbc bridge driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// Open a connection to the database
Connection conn = DriverManager.getConnection("[jdbcURL]",
"[login]", "[passwd]");

// Get DatabaseMetaData
DatabaseMetaData dbmd = conn.getMetaData();

// Get all table types.
ResultSet rs = dbmd.getTableTypes();

// Printout table data
while(rs.next())
{
// Printout
System.out.println("Type: " + rs.getString(1));
}

// Close database resources
rs.close();
conn.close();
}

(Continued on next question...)

Other Interview Questions