Wednesday, December 24, 2008

What is difference between DML and DDL in SQL Server ?

DML : The statement that works with data in database is called Data manipulation language.

Example:

  • SELECT - Get rows from tables
  • UPDATE - Update the rows of tables
  • DELETE - Remove rows from tables
  • INSERT - Add new rows to tables

DDL: The Statement that works with object in database is called Data Definition language.

Example:

  • Create Table Statement
  • Create Database Statement
  • Create Index Statement
  • Drop Statement
  • Alter Statement
  • Drop table Statemet
  • Drop Database Statement

No comments:

Shared Button