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.