Differentiate between DDL and DML commands.

Q. Differentiate between DDL and DML commands.

Answer =

DDL:-

1. DDL is Data Definition Language

2. These are used to define data structure

3. It is used to define database structure or schema

4. Commands are: CREATE, ALTER, DROP, TRUNCATE, RENAME

5. It works on whole table

6. It do not have a where clause to filter

7. Changes done by DDL commands cannot be rolled back

8. Example --  Drop table student

DML:-

1. It is Data Manipulation Language

2. It is used to manipulate the existing databases.

3. It is used for managing data within schema objects

4. Commands are: SELECT, INSERT, DELETE, UPDATE, MERGE, CALL

5. It works on one or more rows

6. It have where clause to filter records

7. Changes can be rolled back

8. It is further classified as procedural and non procedural

9. Example --- Select * from student