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