# ALTER DATABASE

The `ALTER DATABASE` command specifies if an existing database should begin using synchronous or asynchronous replication.

## Syntax

```
ALTER DATABASE <database_name> { SET | WITH } { SYNC | ASYNC } REPLICATION;

```

## Remarks

* `<database_name>` is the name of the existing database for which you want to specify the replication setting.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.

## Example

The following example specifies that the database `database_name` should begin using synchronous replication.

```sql
ALTER DATABASE database_name SET SYNC REPLICATION;

```

**Related Topics**

* [CREATE DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/create-database.md)

***

Modified at: June 11, 2026

Source: [/cloud/reference/sql-reference/data-definition-language-ddl/alter-database/](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl/alter-database/)

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