DDL, DML, DCL and TCL Commands in Sql Server

List of TCL

COMMIT - Saves work done in transactions ROLLBACK - Restores database to original state since the last COMMIT command in transactions SAVE TRANSACTION - Sets a savepoint within a transacti

List of DDL

CREATE - Creates objects in the database ALTER - Alters objects of the database DROP - Deletes objects of the database TRUNCATE - Deletes all records from a table and resets table identity to initial value.

List of DCL

GRANT - Gives user's access privileges to database REVOKE - Withdraws user's access privileges to database given with the GRANT command

List of DML

SELECT - Retrieves data from a table INSERT - Inserts data into a table UPDATE - Updates existing data into a table DELETE - Deletes all records from a table

What is a DCL

is Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.

What is a DDL?

is Data Definition Language. It is used to create and modify the structure of database objects in database.

What is a DML?

is Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.

What is TCL

is Transactional Control Language. It is used to manage different transactions occurring within a database.

What is a A SAVEPOINT

is like markers. When executing a long transaction, it is a good programming practice to set up periodic savepoints so that we can roll back to the save point in case the transaction fails.