Show TOC

lock_table_statementLocate this document in the navigation structure

Use

The LOCK TABLE (lock_table_statement) SQL statement is accepted by SAP MaxDB with the following syntax restrictions: If ROW EXCLUSIVE, SHARE ROW EXCLUSIVE or EXCLUSIVE is specified, SAP MaxDB sets an exclusive lock for the table. Concurrent requests on the table are therefore not possible.

More Information

SQL Statements: Differences

Concepts of the Database System, SQL Locks