# UNLOCK TABLES

Releases all table locks on all databases in the cluster.

After the locks are released, any previously blocked transactions resume.

## Syntax

```
UNLOCK TABLES [ON db_name];

```

## Arguments

* `db_name`: name of the database

## Remarks

* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)
*

## Example

```sql
UNLOCK TABLES;

```

## Related Topics

* [FLUSH TABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/flush-tables.md)

***

Modified at: January 9, 2023

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/unlock-tables/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/unlock-tables/)

(An index of the documentation is available at /llms.txt)