$sql.metaData.getVersionColumns

Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.

Syntax	$sql.metaData.getVersionColumns{jdbcProfileName}{String catalog}{String schema}{String table}
Documentation	Retrieves 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 => whether this is 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 : Paramter: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search table - a table name; must match the table name as it is stored in the database Returns: a ResultSet object in which each row is a column description Throws: SQLException - if a database access error occurs
Examples

Group	SQL
Minimum required transaction-mode:	NONE
Required scripting permission of the developer	PERMISSION_FL_BASIC
Minimum parameters	4
Maximum parameters	4