W3Schools Learner's Blog

W3Schools Programming knowledge summary website

div

1/03/2018

SQL Alter DataBase

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
    <>

No comments:

Post a Comment

Note: only a member of this blog may post a comment.