SQL Commands

The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE,DELETE, and DROP. These commands can be classified into groups based on their nature:

DDL - Data Definition Language:

CREATE:- Creates a new table, a view of a table, or other object in database
ALTER: -Modifies an existing database object, such as a table.
DROP:- Deletes an entire table, a view of a table or other object in the database.

DML - Data Manipulation Language:

INSERT:- Creates a record
UPDATE:- Modifies records
DELETE :- Deletes records

DCL - Data Control Language:

GRANT:- Gives a privilege to user
REVOKE:- Takes back privileges granted from user

DQL - Data Query Language:

SELECT:- Retrieves certain records from one or more tables