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.
• 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