Please enable JavaScript.

Coggle requires JavaScript to display documents.

SQL STATEMENT CATEGORIES (DATA MANIPULATION LANGUAGE (DML) (USED TO ACCESS…

- - - - TO QUERY INFORMATION
    - - ADD NEW ROWS
    - - MODIFY EXISTING ROWS
    - - DELETE EXISTING ROWS
    - - TO PERFORM A CONDITIONAL UPDATE OR INSERT OPERATION
    - - TO SEE EXECUTION PLAN OF SQL
    - - LOCK A TABLE TO RESTRICT ACCESS
- - - - CREATE OBJECTS
    - - MODIFY OBJECTS
    - - DROP OBJECTS
    - - RENAME OBJECTS
    - - DELETE ROWS WITHOUT DROPPING THE STRUCTURE
    - - MANAGE ACCESS PRIVILEGES
    - - AUDIT DATABASE USE
    - - TO ADD A DESCRIPTION ABOUT THE OBJECT IN THE DICTIONARY
- - - - SAVES THE CHANGES MADE BY DML STATEMENTS
    - - POINT OR MARK IN A TRANSACTION FOR A POSSIBLE ROLLBACK
    - - DISCARD THE CHANGES MADE BY DML STATEMENTS
    - - DEFINE PROPERTIES FOR TRANSACTION
- - - - TO CONTROL SESSION PROPERTIES
    - - ENABLE/DISABLE ROLES