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.
Next Topic: SQL data type. Previous Topic: Database overview.
