LOCK

Synopsis

Use the LOCK statement to lock a table.

Syntax

• Grammar
• Diagram

lock_table ::= LOCK [ TABLE ] { { [ ONLY ] name [ * ] } [ , ... ] } 
               [ IN lockmode MODE ] [ NOWAIT ]
lockmode ::= ACCESS SHARE
             | ROW SHARE
             | ROW EXCLUSIVE
             | SHARE UPDATE EXCLUSIVE
             | SHARE
             | SHARE ROW EXCLUSIVE
             | EXCLUSIVE
             | ACCESS EXCLUSIVE

lock_table

lockmode

Semantics

lock_table

name

Specify an existing table to lock.

lockmode

• Only ACCESS SHARE lock mode is supported at this time.
• All other modes listed in lockmode are under development.

ACCESS SHARE
| ROW SHARE
| ROW EXCLUSIVE
| SHARE UPDATE EXCLUSIVE
| SHARE
| SHARE ROW EXCLUSIVE
| EXCLUSIVE
| ACCESS EXCLUSIVE

See also

• SET TRANSACTION