User`s guide

7 Functions — Alphabetical List
7-6
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.