Saturday, 26 March 2011

Filled Under:

Types of sql statements

  • DML
    • DML is abbreviation of Data Manipulation Language.
    • Examples: UPDATE, INSERT, DELETE statements
  • DDL
    • DDL is abbreviation of Data Definition Language.
    • Examples: CREATE, ALTER, DROP statements
  • DCL
    • DCL is abbreviation of Data Control Language.
    • Examples: GRANT, REVOKE statements
  • TCL
    • TCL is abbreviation of Transactional Control Language.
    • Examples: COMMIT, ROLLBACK statements
  • DQL
    • DQL is abbreviation of Data Query Language.
    • Examples: SELECT statements
Ref: here

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)