SQL Server - DDL, DML, DQL, DCL, TCL Statements in SQL Server

                                           SQL (Structured Query Language)

               

In 1970 E.F Codd introduced relational model with the name DSALPHA language then IBM developed simplified version of DSALPHA and name it as SQUARE and also used this language in a system project then again IBM modified square into SEQL (Structured English Query Language) again they modified SEQL and they released simplified version of SEQL i.e. SQL, after that in 1986 they are defined ANSI/ISO standard on SQL

SQL Command Set

1. DDL (Data Definition Language)

                * Create

                * Alter

                * Drop

                * Truncate

                * Rename

Except Truncate command all the above commands will works on columns in the table or works with structure of the table where as Truncate command will works on rows in the table .

To know more about DDL Commands click here.

2. DML (Data Manipulation Language)

                * Insert

                * Update

                * Delete

All the above commands will works on rows in the table .

To know more about DML Commands click here.

3. DCL (Data Control language)

                * Grant - Used to give permissions to the user .

                * Revoke - Used to remove permissions from the user

To know more about DCL Commands click here .

4. TCL (Transaction Control Language)

                * Rollback - used to cancel the execution of SQL Commands

                * Commit   - used to make the transaction permanent or changes will be effected                                                        permanently in the table

To know more about TCL Commands click here.

5. DQL/DRL (Data Query Language / Data Retrieval Language)

                * Select - Used to access the records from the table


To know more about DQL / DRL Commands click here.