getVersionColumns( catalog, schema, table )

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

schema

A schema name

table

A table name

If catalog is "" (the empty string), only procedures without a catalog are returned.

If catalog is the null value, catalog names are not part of the selection criteria.

If schema is "" (the empty string), only procedures without a schema are returned.