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.

Leave a Reply

Your email address will not be published. Required fields are marked *