Pages

Men

rh

6/04/2012

Basic of SQL Server

DDL: -
Data Definition Language
Commands: Create, Alter, Drop, Truncate and Rename

DML:-
Data Manipulation Language
Commands: Insert, Update and Delete

DRL:-
Data Retrieval Language
Commands: Select

TCL:-
Transaction Control Language
Commands: Commit, Save-point and Rollback

DCL:-
Data Control Language
Commands: Grant and Revoke

No comments :

Post a Comment