Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

bestrowid

(Not recommended) Unique identifier for row in database table

bestrowid has been removed.

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.

Related Examples

See Also

| | |

Introduced before R2006a

Was this topic helpful?