- DBMS Tutorial
- DBMS - Home
- DBMS - Overview
- DBMS - Architecture
- DBMS - Data Models
- DBMS - Data Schemas
- DBMS - Data Independence
- Entity Relationship Model
- DBMS - ER Model Basic Concepts
- DBMS - ER Diagram Representation
- DBMS - Generalization, Aggregation
- Relational Model
- DBMS - Codd's Rules
- DBMS - Relational Data Model
- DBMS - Relational Algebra
- DBMS - ER to Relational Model
- DBMS- SQL Overview
- Relational Database Design
- DBMS - Database Normalization
- DBMS - Database Joins
- Storage and File Structure
- DBMS - Storage System
- DBMS - File Structure
- Indexing and Hashing
- DBMS - Indexing
- DBMS - Hashing
- Transaction And Concurrency
- DBMS - Transaction
- DBMS - Concurrency Control
- DBMS - Deadlock
- Backup and Recovery
- DBMS - Data Backup
- DBMS - Data Recovery
- DBMS Useful Resources
- DBMS - Quick Guide
- DBMS - Useful Resources
- DBMS - Discussion
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. |
- Related Articles
- 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 Primary key and Foreign key 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 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 &&
- Difference between and in Ionic framework?
Advertisements