What are DDL and DML

0 votes
I have heard the terms DDL and DML in reference to databases, but I don't understand what they are.

What are they and how do they relate to SQL?
Feb 8 in Database by Neha
• 8,560 points
167 views

1 answer to this question.

0 votes

SQL Commands have subcategories like DDL, DML, DCL and TCL

DDL is defined as Data Definition Language : DDL is used to define data structures which deals with database descriptions.

For example, 

CREATE: It helps to create database 
ALTER : it helps to alter the pre-existing data
DROP: It helps to delete objects or data from the database
TRUNCATE: It remove all records from a table
COMMENT: It helps to add comments to the data dictionary.
RENAME : It helps to rename an object in the database


DML is defined by Data Manipulation Language to manipulate data itself with the following commands:

SELECT : it helps to retrieve data from one or more tables in the database
INSERT : it helps to insert data into a existing table
UPDATE : it helps to update existing data within a existing table
DELETE : it helps to delete all records from a table

answered Feb 8 by Vaani
• 7,020 points

Related Questions In Database

0 votes
1 answer

What is a Relationship and what are they?

Relation or links are between entities that ...READ MORE

answered Oct 23, 2018 in Database by DataKing99
• 8,240 points
238 views
0 votes
1 answer

What are VDL and SDL?

VDL(View Definition Language): Represents user views and ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
• 8,240 points
5,627 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,240 points
1,550 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,390 points
626 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

answered Nov 12, 2018 in Database by Sahiti
• 6,380 points
83,443 views
0 votes
1 answer

What are DDL and DML?

DDL DML DDL stands for Data Definition Language. DML stands ...READ MORE

answered Jun 1 in Others by Sohail
• 2,960 points
51 views
0 votes
0 answers

What are DDL and DML?

What are they and how do they ...READ MORE

Jun 9 in Others by polo
• 1,500 points
49 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by Parth
• 4,630 points
895 views
0 votes
1 answer
0 votes
1 answer

What is the difference between SQL, PL-SQL and T-SQL?

SQL SQL is the standard language for relational ...READ MORE

answered Feb 16 in Database by Vaani
• 7,020 points
113 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP