ALTER DATABASE Syntax


ALTER {DATABASE | SCHEMA} [db_name] alter_specification ...

ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_specification:

[DEFAULT] CHARACTER SET [=] charset_name
 | [DEFAULT] COLLATE [=] collation_name

ALTER DATABASE enables you to change the overall characteristics of a database. These characteristics are stored in the db.opt file in the database directory. To use ALTER DATABASE, you need the ALTER [688] privilege on the database. ALTER SCHEMA is a synonym for ALTER DATABASE.