DDL in MySQL

DDL stands for Data Definition language. DDL is used for defining database schemas. We can use DDL to perform below operations.
  • Create table
  • Drop table
  • Alter table
  • Rename table
  • Truncate table
  • Enforce referential integrity
  • Specify default values for the columns
  • Specify if column values can have NULL values or not
  • Specify if column values can have only unique values or not
  • Specify data type for each column in a table
 

Here is the output of above example.


Complex problems, Simple Solutions