Purpose
This statement is used to release all table locks held by the current session.
Note
For OceanBase Database V4.3.5, the UNLOCK TABLES statement is supported starting from V4.3.5 BP2.
Limitations and considerations
UNLOCK TABLES does not automatically commit transactions.
Syntax
UNLOCK {TABLE | TABLES};
Parameters
| Parameter | Description |
|---|---|
| UNLOCK {TABLE | TABLES} | Releases all table locks held by the current session. UNLOCK TABLE is a synonym for UNLOCK TABLES. |
Example
Release all table locks held by the current session.
UNLOCK TABLES;