SQL Commands



There are 16 SQL commands separated into common group.

  1. DDL 
  2. DML 
  3. DCL
  4.  TCL
 
DDL – Data Definition Language following are the commands come under DDL.
  • Create 
  • Truncate 
  • Rename 
  • Alter 
  • Drop 
  • Comment
 
DML – Data Definition Language following are the commands come under DML.
  • Select 
  • Insert 
  • Delete 
  • Update 
  • Merge
DCL – Data Control Language following are the commands comes under DCL.
  • Grant 
  • Revoke  
TCL – Transaction Control Language following are the commands comes under TCL.
  • Commit 
  • Rollback 
  • Save point

 
 
Previous
Next Post »