SQL Alter Database

SQL Alter Database is used to modify the structure of existing database.

Understand with Example

The Tutorial illustrate an example from 'SQL Alter Database'. To grasp the example we create a database 'komal' using create database  keyword.

Create Database

Create Database komal;

Syntax

The Alter Syntax below is used to redefine the existing structure of database. 

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

Query

ALTER DATABASE komal COLLATE ='binary';

Result

Ater Successful ....

Related Tags for SQL Alter Database:

More Tutorials from this section

• Mysql Alter Column
• Mysql Alter Data Type
• Mysql Alter Table
• MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
• Mysql add primary key
• Mysql Alter Add Column
• Mysql Alter Add Multiple Columns
• Mysql Alter Autoincrement
• Mysql Alter Column Datatype
• Mysql Alter Column Default
• Mysql Alter Column
• Mysql Alter Column Primary Key
• Mysql Alter Column Size
• Mysql Alter Column
• Mysql Alter Command
• Mysql Alter Constraint
• Mysql Alter Data Type
• Mysql Alter Drop
• Mysql Alter Foreign Key
• Mysql Alter Multiple Columns

Ask Questions?    Discuss: SQL Alter Database  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):