Differentiate Between DDL And DML Commands With Example.

The difference between DDL and DML are:

DDL-Data Definition Language

DML-Data Manipulation Language

It is declarative

It is imperative

DDL is used to define data structures

DML is used to manipulate data

DDL defines the column of the table

DML adds or updates the row of the table

DDL is not further classified

DML is further classified into

Procedural DML

Non-Procedural DML

DDL does not use the WHERE clause in its statement

DML uses the WHERE clause in its statements

DDL commands examples are

CREATE

ALTER

DROP

DML commands examples are

INSERT

UPDATE

DELETE

Explore more such questions and answers at BYJU’S.

Was this answer helpful?

 

0 (0)

(1)
(0)

Choose An Option That Best Describes Your Problem

Thank you. Your Feedback will Help us Serve you better.

Leave a Comment

Your Mobile number and Email id will not be published. Required fields are marked *

*

*

BOOK

Free Class

Ask
Question