Background documentationlock_table_statement Locate this document in the navigation structure


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, Locks