ALTER DATABASE Syntax

10 February 2012 By Praveen Macherla 474 views No Comment
0 Flares Twitter 0 Facebook 0 Google+ 0 0 Flares ×

Alter Database command enables you to change the overall characteristics of a database.

ALTER {DATABASE | SCHEMA} [db_name] alter_specification …
alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name

Example:

Tags: ,