
DatabaseMetaData
68
|
JDBC Pocket Reference
ResultSet getBestRowIdentifier(String catalog, String schema,
String table, int scope, boolean nullable)
Returns a result set that defines which columns best uniquely
identify a row. The result set is defined as follows:
SCOPE
A short value that describes the actual scope of the result.
It is one of the following constants:
bestRowTemporary
bestRowTransaction
bestRowSession
COLUMN_NAME
The column name as a String
DATA_TYPE
A short from java.sql.Types
TYPE_NAME
The database-dependent name, or user-defined type
(UDT) name, as a
String value
COLUMN_SIZE
An int value that describes the precision of the data type
BUFFER_LENGTH
An int value that is not used in this method
DECIMAL_DIGITS
A short value that describes the scale of the data type
PSEUDO_COLUMN
A short value that indicates whether or not the column is
a pseudo column. It is one of the following constants:
bestRowUnknown
bestRowNotPseudo
bestRowPseudo
ResultSet getCatalogs( )
Returns a result set with one column, a String value that lists
the catalog names.
String getCatalogSeparator( )
Returns the separator used between catalog and table name.
String getCatalogTerm( )
Returns the database’s term for “catalog.”