Syntax of SQL statement is as follows...
SELECT * FROM TABLE_NAME
where select is representing the action and * is the required data for which action will be performed.
TABLE_NAME is the object on which action will be performed. It can be a table name, view, stored procedure etc.
SQL statement is not case sensitive.
Some databases has restriction to apply semicolon at the end of each statement, but microsoft access and SQL server do not apply this restriction.
SQL statements can be divided into two parts.
Data Manipulation Language (DML)
- Select
- Update
- Delete
- Insert Into
Data Definition Language (DDL)
- Create Database
- Alter Database
- Create Table
- Alter Table
- Drop Table
- Create Index
- Drop Index
No comments:
Post a Comment