Database Toolbox™

bestrowid - Unique identifier for row in database table

Syntax

b = bestrowid(dbmeta, 'cata', 'sch')
b = bestrowid(dbmeta, 'cata', 'sch', 'tab')

Description

• b = bestrowid(dbmeta, 'cata', 'sch') returns the optimal set of columns in a table that uniquely identifies:

  a row in the schema sch, in the catalog cata, for the database whose database metadata object is dbmeta.

b = bestrowid(dbmeta, 'cata', 'sch', 'tab') returns the optimal set of columns that uniquely identifies a row in table tab, in the schema sch, in the catalog cata, for the database whose database metadata object is dbmeta.

Examples

Run bestrowid, passing it the following arguments:

• dbmeta, the database metadata object

• msdb, the catalog

• geck, the schema

• builds, the table

b = bestrowid(dbmeta, 'msdb', 'geck', 'builds') 
b =
     'build_id'

The result indicates that each entry in the build_id column is unique and identifies the row.

See Also

columns, dmd, get, tables

attr

clearwarnings