SQL Commands

The SQL command object is used to specify what type of interaction with a database.

Commonly used SQL command

SQL CommandDescription
CREATE DATABASECreates a new database
CREATE TABLECreates a new table
ALTER DATABASEModifies a database
ALTER TABLEModifies a table
DROP TABLEDeletes a table
CREATE INDEXCreates an index
DROP INDEXDeletes an index
SELECTFetch data from database tables
UPDATEModify data in a database table
DELETEDeletes data from a database table
INSERT INTOInserts new data into a database table

Above SQL query are often used and always starts with these commands.