Junior
What is the difference between DML and DDL?
sobes.tech AI
Answer from AI
Data Definition Language (DDL) is used to define or modify the structure of a database (e.g., creating, dropping tables). Data Manipulation Language (DML) is used to work with data stored in the database (e.g., inserting, updating, deleting records).
DDL commands:
- CREATE
- ALTER
- DROP
- TRUNCATE
- RENAME
DML commands:
- SELECT
- INSERT
- UPDATE
- DELETE
- MERGE
- CALL
- EXPLAIN PLAN
- LOCK TABLE