|
Gets 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
|
Syntax
getVersionColumns(string catalog, string schema, string table)
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
|
