DatabaseMetaData.getVersionColumns
Interface Overview | Interface Members |
This Package |
All Packages
public abstract ResultSet getVersionColumns( String catalog,
String schema,
String table ) throws SQLException
Parameters
- catalog
- a catalog name; "" retrieves those without a
catalog; null means drop catalog name from the selection criteria
- schema
- a schema name; "" retrieves those without a schema
- table
- a table name
Returns
ResultSet - each row is a column description
Description
Get a description of a table's columns that are automatically
updated when any value in a row is updated. They are
unordered.
Each column description has the following columns:
- SCOPE short => is not used
- COLUMN_NAME String => column name
- DATA_TYPE short => SQL data type from java.sql.Types
- TYPE_NAME String => Data source dependent type name
- COLUMN_SIZE int => precision
- BUFFER_LENGTH int => length of column value in bytes
- DECIMAL_DIGITS short => scale
- PSEUDO_COLUMN short => is this a pseudo column
like an Oracle ROWID
- versionColumnUnknown - may or may not be pseudo column
- versionColumnNotPseudo - is NOT a pseudo column
- versionColumnPseudo - is a pseudo column
Exceptions
SQLException
if a database-access error occurs.