SQL Syntax

Syntax:

Syntax is a set of rules and guidelines which defines the structure of statements in a computer language.

SQL syntax:

SQL syntax is a set of rules and guidelines which defines the structure of SQL statements. 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.

- See more at: http://www.beginnerstutorialexamples.com/sql-syntax/#sthash.r3FcudCK.dpuf