Welcome to Milindanath's Blog

What are DML and DDL in SQL

DML - Data Manipulation Language
DDL - Data Definition Language

DML
SQL executes queries (select), update, insert and delete records of a database.These actions of SQL form the DML.
DDL
DDL part of SQL permits to create,delete or change database tables. In addition we can create indexes(keys), specify links between tables and add constraints between tables.
-CREATE TABLE
-ALTER TABLE
-DROP TABLE
-CREATE INDEX
-DROP INDEX

posted by Milindanath @ 10:55 PM