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 CommandExamples
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

\"SQL