getVersionColumns()

Previous Next

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