Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training

SQL Alter Database

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

Ads

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

 

 

 

Advertisements

Share on Google+Share on Google+

SQL Alter Database

Posted on: April 3, 2006 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: SQL Alter Database  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads