Saturday, March 1, 2014

DDL vs DML in SQL Server

DDL
Data Definition Language (DDL) statements are used to define the database structure or schema. Examples:

  • CREATE - to create objects in the database
  • ALTER - alters the structure of the database
  • DROP - delete objects from the database

DML
Data Manipulation Language (DML) statements are used for managing data within schema objects. Examples:


  • SELECT - retrieve data
  • INSERT - add data
  • UPDATE - modify data
  • DELETE - remove data
Note : This is not limited to SQL Server

0 comments:

Post a Comment