SQL Tutorial

DDL (Data Definition Language)

As the name suggests, these queries define the data structure. Like the structure of a table or schema, and modify it.

  • CREATE: This command creates tables, databases, schema, etc.
  • DROP: This command is used to drop tables and other database objects.
  • ALTER: This command is used to alter the definition of database objects.
  • TRUNCATE: This command removes tables, procedures, views, and other database objects.
  • ADD COLUMN: This command adds any column to the table schema.
  • DROP COLUMN: This command drops a column from any table structure.

About the author