Database Toolbox

versioncolumns

Get automatically updated table columns

Syntax

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

Description

vl = versioncolumns(dbmeta, 'cata') returns the list of all columns that are automatically updated when any row value is updated, for the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

vl = versioncolumns(dbmeta, 'cata', 'sch') returns the list of all columns that are automatically updated when any row value is updated, for the schema sch, in the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

vl = versioncolumns(dbmeta, 'cata', 'sch', 'tab') returns the list of all columns that are automatically updated when any row value is updated, in the table tab, for the schema sch, in the catalog cata, for the database whose database metadata object is dbmeta, where dbmeta was created using dmd.

Examples

Type

vl = versioncolumns(dbmeta,'orcl','SCOTT','BONUS','SAL')

MATLAB returns

vl =
     {}

In this example:

• dbmeta is the database metadata object
• orcl is the catalog cata
• SCOTT is the schema sch
• BONUS is the table tab
• SAL is the column name l

The results show an empty set, meaning no columns automatically update when any row value is updates.

See Also

columns, dmd, get

update

width