Java DatabaseMetaData .getColumns (String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
Syntax
DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) has the following syntax.
ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
Example
In the following code shows how to use DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) method.
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
//from w w w. j a v a 2s . c o m
public class Main {
public static void main(String[] args) throws Exception {
Connection conn = getHSQLConnection();
DatabaseMetaData md = conn.getMetaData();
ResultSet r = md.getColumns("", "", "yourTableName", "%");
while (r.next())
System.out.println("\t" + r.getString(4) + " : "
+ r.getString(6));
conn.close();
}
private static Connection getHSQLConnection() throws Exception {
Class.forName("org.hsqldb.jdbcDriver");
String url = "jdbc:hsqldb:data/tutorial";
return DriverManager.getConnection(url, "sa", "");
}
}