Data definition language – (DDL) in MySQL

DDL stands for Data Definition language. DDL is used for defining database schemas.

We can use DDL to perform below operations.

  1. Create table
  2. Drop table
  3. Alter table
  4. Rename table
  5. Truncate table
  6. Enforce referential integrity
  7. Specify default values for the columns
  8. Specify if column values can have NULL values or not
  9. Specify if column values can have only unique values or not
  10. Specify data type for each column in a table

You may also like...