SQL Commands

The Most Use and Important SQL Commands

• SELECT Command is use to extracts data from a database
• UPDATE Command is use to updates data in a database
• DELETE Command is use to deletes data from a database
• INSERT INTO Command is use to inserts new data into a database
• CREATE DATABASE Command is use to creates a new database
• CREATE TABLE  Command is use to creates a new table
• CREATE INDEX Command is use to creates an index
• ALTER DATABASE Command is use to modifies a database
• ALTER TABLE Command is use to  modifies a table
• GRANT  Command is use to Gives a privilege to user
• REVOKE  Command is use to Takes back privileges granted from user
• DROP TABLE Command is use to deletes a table
• DROP INDEX Command is use to deletes an index

DDL "Data Definition Language"

• CREATE 
• ALTER 
• DROP

DML "Data Manipulation Language"

• INSERT 
• UPDATE
• DELETE

DCL "Data Control Language"

• GRANT 
• REVOKE 

DQL "Data Query Language"

• SELECT