lockscheme

Returns the locking scheme of the specified object as a string.

Syntax

lockscheme(object_name)
lockscheme(object_id [, db_id])

Parameters

Examples

Usage

  • lockscheme returns varchar(11) and allows NULLs.

  • lockscheme defaults to the current database if you:
    • Do not provide a fully qualified object_name.

    • Do not provide a db_id.

    • Provide a null for db_id.

  • If the specified object is not a table, lockscheme returns the string “not a table.”

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute lockscheme.