Prerequisite – DDL, DQL, DML, DCL and TCL Commands
DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL.
DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.
Difference between DDL and DML:
|It stands for Data Definition Language.||It stands for Data Manipulation Language.|
|It is used to create database schema and can be used to define some constraints as well.||It is used to add, retrieve or update the data.|
|It basically defines the column (Attributes) of the table.||It add or update the row of the table. These rows are called as tuple.|
|It doesn’t have any further classification.||It is further classified into Procedural and Non-Procedural DML.|
|Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.||BASIC command present in DML are UPDATE, INSERT, MERGE etc.|
|DDL does not use WHERE clause in its statement.||While DML uses WHERE clause in its statement.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- SQL | DDL, DQL, DML, DCL and TCL Commands
- SQL | DDL, DML, TCL and DCL
- Difference between DDL and TCL
- Difference between DML and TCL
- DDL Full Form
- DML Full Form
- Difference between OLAP and OLTP in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Difference between RDBMS and DBMS
- Difference between 1NF and 2NF in DBMS
- Main difference between Timestamp protocol and Thomos write rule in DBMS
- Difference between Trigger and Procedure in DBMS
- Difference between 2NF and 3NF in DBMS
- Difference between 3NF and BCNF in DBMS
- Difference between Cursor and Trigger in DBMS
- Difference between File System and DBMS
- Difference between Generalization and Specialization in DBMS
- Difference between Schema and Instance in DBMS
- Difference between Database and DBMS
- Difference between Assertions and Triggers in DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.