SQL Alter Database

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

SQL Alter Database

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

 

 

 

Tutorials

  1. MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
  2. Views in SQL
  3. SQL Primary Key
  4. SQL Auto increment Primary Key
  5. Mysql Alter View
  6. Mysql add primary key
  7. Mysql Alter Add Column
  8. Mysql Alter Add Multiple Columns
  9. Mysql Alter Column Datatype
  10. Mysql Alter Column
  11. Mysql Alter Column Primary Key
  12. Mysql Alter Column Size
  13. Mysql Alter Command
  14. Mysql Alter Drop
  15. Mysql Alter Remove Column
  16. Mysql Alter Rename Column
  17. Mysql Alter Table Primary Key
  18. Mysql Alter Multiple Columns
  19. Mysql Alter Autoincrement
  20. Mysql Alter Table
  21. Mysql Alter Column
  22. Mysql Alter Data Type
  23. Mysql Time Range
  24. Mysql Date Quarter
  25. Mysql Alter Unique Key
  26. Mysql Alter Table Syntax
  27. Mysql Alter Table Identity
  28. Mysql Alter Not Null
  29. Mysql Alter Foreign Key
  30. Mysql Alter Constraint
  31. Mysql Alter Column Default
  32. SQL Alter Column Syntax
  33. SQL Alter Table Syntax
  34. SQL Alter Database
  35. Mysql Alter Rename Table
  36. MySQL PHP Query delete
  37. MySQL PHP Update
  38. SQL Alter Table