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

| | |

Was this topic helpful?