Purpose
You can use this statement to release all table locks held by the current session.
Limitations and considerations
UNLOCK TABLES does not proactively commit the transaction.
Syntax
UNLOCK {TABLE | TABLES};
Parameters
| Parameter | Description |
|---|---|
| UNLOCK {TABLE | TABLES} | Specifies to release all table locks held by the current session. UNLOCK TABLE is a synonym of UNLOCK TABLES. |
Examples
Release all table locks held by the current session.
UNLOCK TABLES;