Learn two categories of SQL statements: DDL and DML.

SQL statements are broadly categorized into two groups: Data Definition Language (DDL) and Data Manipulation Language (DML).


DDL is a set of commands used to create, modify, and delete database objects such as tables, views, indexes, and constraints. Here are a few DDL commands:

  • CREATE: Create new database objects such as tables.

  • ALTER: Modify existing database objects such as adding or removing columns from the table.

  • DROP: Delete a database object such as a table or index.

  • TRUNCATE: Delete all data from a table without deleting the table itself.

  • RENAME: Rename an existing database object, like a table or column.

Get hands-on with 1200+ tech skills courses.