> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/transactions/transactions-unlock-tables.md).

# UNLOCK TABLES

## Syntax

```bnf
UNLOCK TABLES
```

## Description

`UNLOCK TABLES` explicitly releases any table locks held by the current session. See [LOCK TABLES](/docs/server/reference/sql-statements/transactions/lock-tables.md) for more information.

In addition to releasing table locks acquired by the [LOCK TABLES](/docs/server/reference/sql-statements/transactions/lock-tables.md) statement, the `UNLOCK TABLES` statement also releases the global read lock acquired by the `FLUSH TABLES WITH READ LOCK` statement. The `FLUSH TABLES WITH READ LOCK` statement is very useful for performing backups. See [FLUSH](/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush.md) for more information about `FLUSH TABLES WITH READ LOCK`.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}