Database Toolbox™

versioncolumns - Automatically update table columns

Syntax

vl = versioncolumns(dbmeta, 'cata')
vl = versioncolumns(dbmeta, 'cata', 'sch')
vl = versioncolumns(dbmeta, 'cata', 'sch', 'tab')

Description

• vl = versioncolumns(dbmeta, 'cata') returns a list of columns that automatically update when a row value updates in the catalog cata, in the database whose database metadata object is dbmeta.

• vl = versioncolumns(dbmeta, 'cata', 'sch') returns a list of all columns that automatically update when a row value updates in:

  • The schema sch

  • In the catalog cata

  • For the database whose database metadata object is dbmeta

• vl = versioncolumns(dbmeta, 'cata', 'sch', 'tab') returns a list of columns that automatically update when a row value updates in:

  • The table tab

  • The schema sch

  • In the catalog cata

  • For the database whose database metadata object is dbmeta

Examples

Get a list of which columns automatically update when a row in the table BONUS updates, in the schema SCOTT, in the catalog orcl, for the database metadata object dbmeta.

vl = versioncolumns(dbmeta,'orcl','SCOTT','BONUS')
vl =
     {}

The results are an empty set, indicating that no columns in the database automatically update when a row value updates.

See Also

columns, dmd, get

update

width