Database Toolbox

bestrowid

Get database table unique row identifier

Syntax

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

Description

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

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

Examples

Type

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

MATLAB returns

b =
     'build_id'

In this example:

• dbmeta is the database metadata object
• msdb is the catalog cata
• geck is the schema sch, is
• builds is the table tab

The results is build_id, which means that every entry in the build_id column is unique and can be used to identify the row.

See Also
columns, dmd, get, tables

attr

clearwarnings