Q

What's the difference between DDL and DML?

What's the difference between DDL and DML? Get the answer and see examples of the Data Manipulation Language and Data Definition Language with help from our DBMS expert.

What's the difference between DDL and DML?

To be pedantic, DMLs and DDLs do exist outside of SQL, but I assume you are asking about the components of SQL.

SQL stands for Structured Query Language. In practice, this is really a misnomer. SQL can do much more than query data – indeed, the language splits neatly into two parts. There is the Data Definition Language (DDL) section and the Data Manipulation Language (DML) section. The former is the part of the language that is used for creating (and/or destroying) database objects such as tables.

Here is an example of DDL code:

CREATE TABLE [dbo].[Customer]
(
      [ID] [int] IDENTITY(1,1) NOT NULL,
      [FName] [varchar](20) NULL,
     [LName] [varcharint](20) NULL,
      [DateOfBirth] [datetime] NOT NULL,

And so on. You can add (within reason) as many columns to the table as you like.

DML statements aren't used to create data structures (or destroy them); they are used to manipulate the data. An example is a SELECT statement:

SELECT ID, FName, LName, DateOfBirth
FROM Customer;

This was first published in March 2010

Dig deeper on Enterprise data architecture best practices

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

1 comment

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close