SQL Alter DataBase

The ALTER DATABASE Statement is used to change characteristics of a database.

After creating a database, we can change its properties by executing ALTER DATABASE statement. The user should have admin privileges for modifying a database.

SQL ALTER DATABASE Statement:

The Syntax for the ALTER DATABASE Statement is:

ALTER DATABASE database_name

[COLLATE collation_name ]

In the above query,

database_name - is the name of the database to be created

- collation_name - - is the default collation for the database

collation_name - This is an optional field and if not provided thanDefault Collation is assigned to database.

ALTER DATABASE Example:

• If you want to modify database “MyDatabase” collation to “Latin General”, then statement would be like,
ALTER DATABASE MyDatabase
<>