Pages

Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

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

Shared Button