Question

Subject : Introduction to Databases

Topic : SQL

What are DDL and DML statements?

Answer 1

Hi, I am here to answer you with the questions you have. I hope you will like an answer and get a clear idea related to the same. So not wasting much time let's get started.

DDL (Data Definition Language): The DDL or Data Definition Language are the commands used in the SQL which are been used for defining the database schema. In simple words we can say that this is used to simply modify and create the structure of the objects in the database schema.

Some of the commands in the DDL are :- CREATE, DROP, ALTER, TRUNCATE, COMMENT, RENAME

DML (Data Manipulation Language): The DML or Data Manipulation Language are the commands which can be used for manipulating the data available in the database. This include many crucial commands in the database.

Some of the commands in the DML are:- INSERT, UPDATE, DELETE

I hope you are able to understand both of the Definitions clearly, if there is any doubt related to the both please comment below.

Thanks and Happy to help :)

HAPPY LEARNING