com.mysql.jdbc
Class DatabaseMetaDataUsingInfoSchema
java.lang.Object
com.mysql.jdbc.DatabaseMetaData
com.mysql.jdbc.DatabaseMetaDataUsingInfoSchema
- All Implemented Interfaces:
- java.sql.DatabaseMetaData
public class DatabaseMetaDataUsingInfoSchema
- extends DatabaseMetaData
DatabaseMetaData implementation that uses INFORMATION_SCHEMA available in
MySQL-5.0 and newer.
The majority of the queries in this code were built for Connector/OO.org by
Georg Richter (georg_at_mysql.com).
Fields inherited from interface java.sql.DatabaseMetaData |
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown |
Method Summary |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
Get a description of the access rights for a table's columns. |
java.sql.ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableName,
java.lang.String columnNamePattern)
Get a description of table columns available in a catalog. |
java.sql.ResultSet |
getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
Get a description of the foreign key columns in the foreign key table
that reference the primary key columns of the primary key table (describe
how one table imports another's key.) This should normally return a
single foreign key/primary key pair (most tables only import a foreign
key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM,
FKTABLE_NAME, and KEY_SEQ. |
java.sql.ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Get a description of a foreign key columns that reference a table's
primary key columns (the foreign keys exported by a table). |
java.sql.ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Get a description of the primary key columns that are referenced by a
table's foreign key columns (the primary keys imported by a table). |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
Get a description of a table's indices and statistics. |
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
Get a description of a table's primary key columns. |
java.sql.ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
Get a description of stored procedures available in a catalog. |
java.sql.ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
Get a description of tables available in a catalog. |
Methods inherited from class com.mysql.jdbc.DatabaseMetaData |
allProceduresAreCallable, allTablesAreSelectable, dataDefinitionCausesTransactionCommit, dataDefinitionIgnoredInTransactions, deletesAreDetected, doesMaxRowSizeIncludeBlobs, extractForeignKeyForTable, extractForeignKeyFromCreateTable, getAttributes, getBestRowIdentifier, getCatalogIterator, getCatalogs, getCatalogSeparator, getCatalogTerm, getConnection, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDefaultTransactionIsolation, getDriverMajorVersion, getDriverMinorVersion, getDriverName, getDriverVersion, getExtraNameCharacters, getIdentifierQuoteString, getJDBCMajorVersion, getJDBCMinorVersion, getMaxBinaryLiteralLength, getMaxCatalogNameLength, getMaxCharLiteralLength, getMaxColumnNameLength, getMaxColumnsInGroupBy, getMaxColumnsInIndex, getMaxColumnsInOrderBy, getMaxColumnsInSelect, getMaxColumnsInTable, getMaxConnections, getMaxCursorNameLength, getMaxIndexLength, getMaxProcedureNameLength, getMaxRowSize, getMaxSchemaNameLength, getMaxStatementLength, getMaxStatements, getMaxTableNameLength, getMaxTablesInSelect, getMaxUserNameLength, getNumericFunctions, getProcedureColumns, getProceduresAndOrFunctions, getProcedureTerm, getResultSetHoldability, getSchemas, getSchemaTerm, getSearchStringEscape, getSQLKeywords, getSQLStateType, getStringFunctions, getSuperTables, getSuperTypes, getSystemFunctions, getTablePrivileges, getTableTypes, getTimeDateFunctions, getTypeInfo, getUDTs, getURL, getUserName, getVersionColumns, insertsAreDetected, isCatalogAtStart, isReadOnly, locatorsUpdateCopy, nullPlusNonNullIsNull, nullsAreSortedAtEnd, nullsAreSortedAtStart, nullsAreSortedHigh, nullsAreSortedLow, othersDeletesAreVisible, othersInsertsAreVisible, othersUpdatesAreVisible, ownDeletesAreVisible, ownInsertsAreVisible, ownUpdatesAreVisible, storesLowerCaseIdentifiers, storesLowerCaseQuotedIdentifiers, storesMixedCaseIdentifiers, storesMixedCaseQuotedIdentifiers, storesUpperCaseIdentifiers, storesUpperCaseQuotedIdentifiers, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsANSI92EntryLevelSQL, supportsANSI92FullSQL, supportsANSI92IntermediateSQL, supportsBatchUpdates, supportsCatalogsInDataManipulation, supportsCatalogsInIndexDefinitions, supportsCatalogsInPrivilegeDefinitions, supportsCatalogsInProcedureCalls, supportsCatalogsInTableDefinitions, supportsColumnAliasing, supportsConvert, supportsConvert, supportsCoreSQLGrammar, supportsCorrelatedSubqueries, supportsDataDefinitionAndDataManipulationTransactions, supportsDataManipulationTransactionsOnly, supportsDifferentTableCorrelationNames, supportsExpressionsInOrderBy, supportsExtendedSQLGrammar, supportsFullOuterJoins, supportsGetGeneratedKeys, supportsGroupBy, supportsGroupByBeyondSelect, supportsGroupByUnrelated, supportsIntegrityEnhancementFacility, supportsLikeEscapeClause, supportsLimitedOuterJoins, supportsMinimumSQLGrammar, supportsMixedCaseIdentifiers, supportsMixedCaseQuotedIdentifiers, supportsMultipleOpenResults, supportsMultipleResultSets, supportsMultipleTransactions, supportsNamedParameters, supportsNonNullableColumns, supportsOpenCursorsAcrossCommit, supportsOpenCursorsAcrossRollback, supportsOpenStatementsAcrossCommit, supportsOpenStatementsAcrossRollback, supportsOrderByUnrelated, supportsOuterJoins, supportsPositionedDelete, supportsPositionedUpdate, supportsResultSetConcurrency, supportsResultSetHoldability, supportsResultSetType, supportsSavepoints, supportsSchemasInDataManipulation, supportsSchemasInIndexDefinitions, supportsSchemasInPrivilegeDefinitions, supportsSchemasInProcedureCalls, supportsSchemasInTableDefinitions, supportsSelectForUpdate, supportsStatementPooling, supportsStoredProcedures, supportsSubqueriesInComparisons, supportsSubqueriesInExists, supportsSubqueriesInIns, supportsSubqueriesInQuantifieds, supportsTableCorrelationNames, supportsTransactionIsolationLevel, supportsTransactions, supportsUnion, supportsUnionAll, updatesAreDetected, usesLocalFilePerTable, usesLocalFiles |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
DatabaseMetaDataUsingInfoSchema
public DatabaseMetaDataUsingInfoSchema(Connection connToSet,
java.lang.String databaseToSet)
getColumnPrivileges
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String columnNamePattern)
throws java.sql.SQLException
- Get a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are
ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- COLUMN_NAME String => column name
- GRANTOR => grantor of access (may be null)
- GRANTEE String => grantee of access
- PRIVILEGE String => name of access (SELECT, INSERT, UPDATE,
REFRENCES, ...)
- IS_GRANTABLE String => "YES" if grantee is permitted to
grant to others; "NO" if not; null if unknown
- Specified by:
getColumnPrivileges
in interface java.sql.DatabaseMetaData
- Overrides:
getColumnPrivileges
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschema
- a schema name; "" retrieves those without a schematable
- a table namecolumnNamePattern
- a column name pattern
- Returns:
- ResultSet each row is a column privilege description
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
DatabaseMetaData.getSearchStringEscape()
getColumns
public java.sql.ResultSet getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableName,
java.lang.String columnNamePattern)
throws java.sql.SQLException
- Get a description of table columns available in a catalog.
Only column descriptions matching the catalog, schema, table and column
name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME
and ORDINAL_POSITION.
Each column description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- COLUMN_NAME String => column name
- DATA_TYPE short => SQL type from java.sql.Types
- TYPE_NAME String => Data source dependent type name
- COLUMN_SIZE int => column size. For char or date types this
is the maximum number of characters, for numeric or decimal types this is
precision.
- BUFFER_LENGTH is not used.
- DECIMAL_DIGITS int => the number of fractional digits
- NUM_PREC_RADIX int => Radix (typically either 10 or 2)
- NULLABLE int => is NULL allowed?
- columnNoNulls - might not allow NULL values
- columnNullable - definitely allows NULL values
- columnNullableUnknown - nullability unknown
- REMARKS String => comment describing column (may be null)
- COLUMN_DEF String => default value (may be null)
- SQL_DATA_TYPE int => unused
- SQL_DATETIME_SUB int => unused
- CHAR_OCTET_LENGTH int => for char types the maximum number
of bytes in the column
- ORDINAL_POSITION int => index of column in table (starting
at 1)
- IS_NULLABLE String => "NO" means column definitely does not
allow NULL values; "YES" means the column might allow NULL values. An
empty string means nobody knows.
- Specified by:
getColumns
in interface java.sql.DatabaseMetaData
- Overrides:
getColumns
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschemaPattern
- a schema name pattern; "" retrieves those without a schematableName
- a table name patterncolumnNamePattern
- a column name pattern
- Returns:
- ResultSet each row is a column description
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
DatabaseMetaData.getSearchStringEscape()
getCrossReference
public java.sql.ResultSet getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTable,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTable)
throws java.sql.SQLException
- Get a description of the foreign key columns in the foreign key table
that reference the primary key columns of the primary key table (describe
how one table imports another's key.) This should normally return a
single foreign key/primary key pair (most tables only import a foreign
key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM,
FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
- PKTABLE_CAT String => primary key table catalog (may be
null)
- PKTABLE_SCHEM String => primary key table schema (may be
null)
- PKTABLE_NAME String => primary key table name
- PKCOLUMN_NAME String => primary key column name
- FKTABLE_CAT String => foreign key table catalog (may be
null) being exported (may be null)
- FKTABLE_SCHEM String => foreign key table schema (may be
null) being exported (may be null)
- FKTABLE_NAME String => foreign key table name being exported
- FKCOLUMN_NAME String => foreign key column name being
exported
- KEY_SEQ short => sequence number within foreign key
- UPDATE_RULE short => What happens to foreign key when
primary is updated:
- importedKeyCascade - change imported key to agree with primary key
update
- importedKeyRestrict - do not allow update of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been updated
- DELETE_RULE short => What happens to the foreign key when
primary is deleted.
- importedKeyCascade - delete rows that import a deleted key
- importedKeyRestrict - do not allow delete of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been deleted
- FK_NAME String => foreign key identifier (may be null)
- PK_NAME String => primary key identifier (may be null)
- Specified by:
getCrossReference
in interface java.sql.DatabaseMetaData
- Overrides:
getCrossReference
in class DatabaseMetaData
- Parameters:
primaryCatalog
- a catalog name; "" retrieves those without a catalogprimarySchema
- a schema name pattern; "" retrieves those without a schemaprimaryTable
- a table nameforeignCatalog
- a catalog name; "" retrieves those without a catalogforeignSchema
- a schema name pattern; "" retrieves those without a schemaforeignTable
- a table name
- Returns:
- ResultSet each row is a foreign key column description
- Throws:
java.sql.SQLException
- if a database access error occurs
getExportedKeys
public java.sql.ResultSet getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Get a description of a foreign key columns that reference a table's
primary key columns (the foreign keys exported by a table). They are
ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
- PKTABLE_CAT String => primary key table catalog (may be
null)
- PKTABLE_SCHEM String => primary key table schema (may be
null)
- PKTABLE_NAME String => primary key table name
- PKCOLUMN_NAME String => primary key column name
- FKTABLE_CAT String => foreign key table catalog (may be
null) being exported (may be null)
- FKTABLE_SCHEM String => foreign key table schema (may be
null) being exported (may be null)
- FKTABLE_NAME String => foreign key table name being exported
- FKCOLUMN_NAME String => foreign key column name being
exported
- KEY_SEQ short => sequence number within foreign key
- UPDATE_RULE short => What happens to foreign key when
primary is updated:
- importedKeyCascade - change imported key to agree with primary key
update
- importedKeyRestrict - do not allow update of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been updated
- DELETE_RULE short => What happens to the foreign key when
primary is deleted.
- importedKeyCascade - delete rows that import a deleted key
- importedKeyRestrict - do not allow delete of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been deleted
- FK_NAME String => foreign key identifier (may be null)
- PK_NAME String => primary key identifier (may be null)
- Specified by:
getExportedKeys
in interface java.sql.DatabaseMetaData
- Overrides:
getExportedKeys
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschema
- a schema name pattern; "" retrieves those without a schematable
- a table name
- Returns:
- ResultSet each row is a foreign key column description
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
getImportedKeys(java.lang.String, java.lang.String, java.lang.String)
getImportedKeys
public java.sql.ResultSet getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Get a description of the primary key columns that are referenced by a
table's foreign key columns (the primary keys imported by a table). They
are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
- PKTABLE_CAT String => primary key table catalog being
imported (may be null)
- PKTABLE_SCHEM String => primary key table schema being
imported (may be null)
- PKTABLE_NAME String => primary key table name being imported
- PKCOLUMN_NAME String => primary key column name being
imported
- FKTABLE_CAT String => foreign key table catalog (may be
null)
- FKTABLE_SCHEM String => foreign key table schema (may be
null)
- FKTABLE_NAME String => foreign key table name
- FKCOLUMN_NAME String => foreign key column name
- KEY_SEQ short => sequence number within foreign key
- UPDATE_RULE short => What happens to foreign key when
primary is updated:
- importedKeyCascade - change imported key to agree with primary key
update
- importedKeyRestrict - do not allow update of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been updated
- DELETE_RULE short => What happens to the foreign key when
primary is deleted.
- importedKeyCascade - delete rows that import a deleted key
- importedKeyRestrict - do not allow delete of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been deleted
- FK_NAME String => foreign key name (may be null)
- PK_NAME String => primary key name (may be null)
- Specified by:
getImportedKeys
in interface java.sql.DatabaseMetaData
- Overrides:
getImportedKeys
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschema
- a schema name pattern; "" retrieves those without a schematable
- a table name
- Returns:
- ResultSet each row is a primary key column description
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
getExportedKeys(java.lang.String, java.lang.String, java.lang.String)
getIndexInfo
public java.sql.ResultSet getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
throws java.sql.SQLException
- Get a description of a table's indices and statistics. They are ordered
by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- NON_UNIQUE boolean => Can index values be non-unique? false
when TYPE is tableIndexStatistic
- INDEX_QUALIFIER String => index catalog (may be null); null
when TYPE is tableIndexStatistic
- INDEX_NAME String => index name; null when TYPE is
tableIndexStatistic
- TYPE short => index type:
- tableIndexStatistic - this identifies table statistics that are
returned in conjuction with a table's index descriptions
- tableIndexClustered - this is a clustered index
- tableIndexHashed - this is a hashed index
- tableIndexOther - this is some other style of index
- ORDINAL_POSITION short => column sequence number within
index; zero when TYPE is tableIndexStatistic
- COLUMN_NAME String => column name; null when TYPE is
tableIndexStatistic
- ASC_OR_DESC String => column sort sequence, "A" =>
ascending, "D" => descending, may be null if sort sequence is not
supported; null when TYPE is tableIndexStatistic
- CARDINALITY int => When TYPE is tableIndexStatisic then this
is the number of rows in the table; otherwise it is the number of unique
values in the index.
- PAGES int => When TYPE is tableIndexStatisic then this is
the number of pages used for the table, otherwise it is the number of
pages used for the current index.
- FILTER_CONDITION String => Filter condition, if any. (may be
null)
- Specified by:
getIndexInfo
in interface java.sql.DatabaseMetaData
- Overrides:
getIndexInfo
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschema
- a schema name pattern; "" retrieves those without a schematable
- a table nameunique
- when true, return only indices for unique values; when false,
return indices regardless of whether unique or notapproximate
- when true, result is allowed to reflect approximate or out of
data values; when false, results are requested to be accurate
- Returns:
- ResultSet each row is an index column description
- Throws:
java.sql.SQLException
- DOCUMENT ME!
getPrimaryKeys
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws java.sql.SQLException
- Get a description of a table's primary key columns. They are ordered by
COLUMN_NAME.
Each column description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- COLUMN_NAME String => column name
- KEY_SEQ short => sequence number within primary key
- PK_NAME String => primary key name (may be null)
- Specified by:
getPrimaryKeys
in interface java.sql.DatabaseMetaData
- Overrides:
getPrimaryKeys
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschema
- a schema name pattern; "" retrieves those without a schematable
- a table name
- Returns:
- ResultSet each row is a primary key column description
- Throws:
java.sql.SQLException
- DOCUMENT ME!
getProcedures
public java.sql.ResultSet getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
throws java.sql.SQLException
- Get a description of stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name
criteria are returned. They are ordered by PROCEDURE_SCHEM, and
PROCEDURE_NAME.
Each procedure description has the the following columns:
- PROCEDURE_CAT String => procedure catalog (may be null)
- PROCEDURE_SCHEM String => procedure schema (may be null)
- PROCEDURE_NAME String => procedure name
- reserved for future use
- reserved for future use
- reserved for future use
- REMARKS String => explanatory comment on the procedure
- PROCEDURE_TYPE short => kind of procedure:
- procedureResultUnknown - May return a result
- procedureNoResult - Does not return a result
- procedureReturnsResult - Returns a result
- Specified by:
getProcedures
in interface java.sql.DatabaseMetaData
- Overrides:
getProcedures
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschemaPattern
- a schema name pattern; "" retrieves those without a schemaprocedureNamePattern
- a procedure name pattern
- Returns:
- ResultSet each row is a procedure description
- Throws:
java.sql.SQLException
- if a database access error occurs- See Also:
DatabaseMetaData.getSearchStringEscape()
getTables
public java.sql.ResultSet getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
throws java.sql.SQLException
- Get a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type
criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and
TABLE_NAME.
Each table description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- TABLE_TYPE String => table type. Typical types are "TABLE",
"VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS",
"SYNONYM".
- REMARKS String => explanatory comment on the table
Note: Some databases may not return information for all tables.
- Specified by:
getTables
in interface java.sql.DatabaseMetaData
- Overrides:
getTables
in class DatabaseMetaData
- Parameters:
catalog
- a catalog name; "" retrieves those without a catalogschemaPattern
- a schema name pattern; "" retrieves those without a schematableNamePattern
- a table name patterntypes
- a list of table types to include; null returns all types
- Returns:
- ResultSet each row is a table description
- Throws:
java.sql.SQLException
- DOCUMENT ME!- See Also:
DatabaseMetaData.getSearchStringEscape()