Syntax:
The structure of statements in a computer language is defined by syntax, which is a set of rules and guidelines.
SQL syntax:
The structure of SQL statements is defined by a set of rules and guidelines known as SQL syntax. SQL is case insensitive.
Commonly used SQL commands:
1. SELECT – It is used to extract data from a database.
2. UPDATE – It is used to update data in a database.
3. DELETE – It is used to delete data from a database.
4. INSERT INTO – It is used to insert new data into a database.
5. CREATE DATABASE – It is used to create a new database.
6. ALTER DATABASE – It is used to modify an existing database.
7. CREATE TABLE – It is used to create a new table.
8. ALTER TABLE – It is used to modify an existing table.
9. DROP TABLE – It is used to delete an existing table.
10. CREATE INDEX – It is used to create an index (search key).
11. DROP INDEX – It is used to delete an existing index.