DDL CONSTRUCTS
1. DDL is Data Definition Language which is used to define data structures. For example: create a table, alter table are instructions in SQL.
2. It is used to create a database schema and can be used to define some constraints as well.
3. It basically defines the column (Attributes) of the table and it does not have any further classification.
4. Basic commands present in DDL is CREATE, DROP, RENAME, ALTER, etc.
5. DDL does not use the WHERE clause in its statement.
DML CONSTRUCTS
1. DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL
2. It is used to add, retrieve, or update the data.
3. It adds or updates the row of the table. These rows are called a tuple. It is further classified into procedural and non-procedural language.
4. BASIC command present in DML are UPDATE, INSERT, MERGE, etc
5. DML uses the WHERE clause in its statement.
0 Comments
Doubts? Please let our team know So that we can serve you better.