- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between DDL and DML in DBMS.
DDL
DDL is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.
DML
DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.
Following are the important differences between DDL and DML.
| Sr. No. | Key | DDL | DML |
|---|---|---|---|
| 1 | Stands for | DDL stands for Data Definition Language. | DML stands for Data Manipulation Language. |
| 2 | Usage | DDL statements are used to create database, schema, constraints, users, tables etc. | DML statement is used to insert, update or delete the records. |
| 3 | Classification | DDL has no further classification. | DML is further classified into procedural DML and non-procedural DML. |
| 4 | Commands | CREATE, DROP, RENAME and ALTER. | INSERT, UPDATE and DELETE. |
Updated on 18-Nov-2020 05:04:06
- Related Questions & Answers
- What are the DML commands in DBMS?
- What are the DDL commands in DBMS?
- Difference between DBMS and RDBMS
- Difference Between Generalization and Specialization in DBMS
- Difference between an SAP ERP system and DBMS
- Difference between SAP ERP and a DBMS system
- State the difference between file systems and DBMS?
- Difference Between Primary key and Foreign key in DBMS
- Difference Between E-R Model and Relational Model in DBMS
- What is the difference between data and information in DBMS?
- Differentiate between OS and DBMS files and OS and DBMS buffer manager
- Distinguish between flat files and databases (dbms)?
- Generate table DDL via a query on MySQL and SQL Server?
- Difference between == and === operator in JavaScript
- Difference between !== and ==! operator in PHP
Advertisements