Mega Code Archive

 

Categories / Java Tutorial / Database

 

DatabaseMetaData Methods for Information on the Databases Contents

ResultSet getProcedures(String catalog, String schemaPattern,String procedureNamePattern); ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern); ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String types[]); ResultSet getschemas(); ResultSet getCatalogs(); ResultSet getTableTypes(); ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern); ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern); ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern); ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable); ResultSet getVersionColumns(String catalog, String schema, String table); ResultSet getPrimaryKeys(String catalog, String schema, String table); ResultSet getImportedKeys(String catalog, String schema, String table); ResultSet getExportedKeys(String catalog, String schema, String table); ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema,String foreignTable); ResultSet getTypeInfo(); ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate);