versioncolumns - Automatically update table columns

Syntax

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

© 1984-2012- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS