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