Important SQL Commands

Here are some of the most widely used SQL commands
*they are not case-sensitive

• SELECT : extracts data from a database
• UPDATE: updates data in a database
• DELETE: deletes data from a database
• INSERT INTO: inserts new data into a database
• CREATE DATABASE: creates a new database
• ALTER DATABASE: modifies a database
• CREATE TABLE: creates a new table
• ALTER TABLE: modifies a table
• DROP TABLE: deletes a table
• CREATE INDEX: creates an index(search key)
• DROP INDEX: deletes an index