SQL COMMANDS
- SQL commands are the instructions used to communicate with a database to perform tasks, functions, and queries with data.
- SQL commands can be used to search the database and to do other functions like creating tables, adding data to tables, modifying data, and dropping tables.
Depending upon SQL Functions, there are five types of SQL Commands.
Sr. No. | SQL Command | Examples |
01) | DDL (Data Definition Language) | CREATE, DROP, ALTER, TRUNCATE |
02) | DQL (Data Query Language) | SELECT |
03) | DML (Data Manipulation Language) | INSERT, UPDATE, DELETE |
04) | TCL (Transaction Control Language) | COMMIT, ROLLBACK |
05) | DCL (Data Control Language) | GRANT, REVOKE |