Saturday, December 15, 2012

SQL Statements


                               SQL Statements





1-DML (Data Manipulation Language)
  1. SELECT
  2. INSERT
  3. UPDATE
  4. DELETE
  5. MERGE



2-DDL (Data Definition Language)
  1. CREATE
  2. ALTER
  3. DROP
  4. RENAME
  5. TRUNCATE
  6. COMMENT
 

3-DCL (Data Control Language)

  1.  GRANT
  2.  REVOKE


4-TCL (Transaction Control Language)
  1. COMMIT
  2. ROLLBACK
  3. SAVEPOINT

No comments:

Post a Comment