Veena

What is Data Definition Language

Commands of DDL

What is Data manipulation Language

Commands of DML

Difference between DDL & DML

 Data Definition Language (DDL) is a
vocabulary used to define data
structures in SQL Server
or
 It is a syntax similar to a computer
programming language for defining data
structures, especially database schemas.

 Data Definition Language (DDL)
statements are used to define the database
structure or schema. Some examples:
 CREATE -CREATE TABLE <table
name>
 ALTER -ALTER TABLE <table name>
 DROP -DROP TABLE <table name>;
 COMMENT - add comments to the data
dictionary
 RENAME – RENAME TABLE <table
name>
 DELETE:-DELETE FROM <table name>

 A data manipulation language (DML) is a
vocabulary used to retrieve and work with
data in SQL Server 2012. Use these
statements to add, modify, query, or remove
data from a SQL Server database.
 DML statements are used for managing data
within tables
 A popular data manipulation language is that
of Structured Query Language (SQL), which
is used to retrieve and manipulate data in a
relational database

 Data Manipulation Language (DML) statements
are used for managing data within schema objects.
Some examples:
 SELECT - retrieve data from the a database
 INSERT -INSERT INTO <table name>
 UPDATE -UPDATE <table name>
 DELETE -DELETE FROM <table name>
 MERGE - UPSERT operation (insert or update)
 CALL - call a PL/SQL or Java subprogram

Diference Between
DDL & DML

Data Definition Language
 Data Manipulation
(DDL) statements are used
to define the database
Language (DML)
structure or schema statements are used
for managing data
 These commands will
within schema object
primarily be used by
database administrators  DML statements are
during the setup and used for managing
removal phases of a
data within tables
database project

Veena

More Related Content

Veena