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.
