SQL Commands
SQL commands are categorized into the following categories:
- DDL : Data Definition Language
- DQL : Data Query Language
- DCL : Data Control Language
- DML : Data Manipulation Language
- TCL : Transaction Control Language
Under these five categories, the following commands are defined
1. DDL
- CREATE
- DROP
- ALTER
- TRUNCATE
- RENAME
2. DML
- INSERT
- UPDATE
- DELETE
- CALL
- LOCK
3. DQL
- SELECT
4. DCL
- GRANT
- REVOKE
5. TCL
- SAVEPOINT
- COMMIT
- ROLLBACK
Comments
Post a Comment