UNLOCK TABLES
Description
This statement is used to release all table locks held by the current session.
Limitations and Considerations
UNLOCK TABLES does not commit transactions.
Syntax
UNLOCK {TABLE | TABLES};
Syntax Description
| Field | Description |
|---|---|
| UNLOCK {TABLE | TABLES} | Releases all table locks held by the current session. UNLOCK TABLE is a synonym for UNLOCK TABLES. |
Examples
Release all table locks held by the current session.
UNLOCK TABLES;