What are SQL DML, DDL, DCL, and TCL Commands, and their abbreviations is the most common question you might face in SQL interviews.
SQL DDL Commands
In SQL, DDL means Data Definition Language. The Sql Server DDL commands are used to create and modify the structure of a database and database objects.
Examples of DDL commands in SQL Server are
- CREATE – Create an object. I mean, create a database, table, triggers, index, functions, stored procedures etc.
- DROP – This SQL DDL command helps to delete objects. For example, delete table, delete database etc.
- ALTER – Used to alter the existing database or its objects structures.
- TRUNCATE – This SQL DML command removes records from tables
- RENAME – Renaming the database objects
SQL DML Commands
DML means Data Manipulation Language. As its name suggests, these Sql Server DML commands will perform data manipulation manipulate data presented in the server).
Examples of DML commands in SQL Server are
- SELECT – Select records or data from a table
- INSERT – Insert data into a database table.
- UPDATE – This SQL DML command will update existing records within a table
- DELETE – Delete unwanted records from a table
SQL DCL Commands
DCL means Data Control Language. These Sql Server DCL commands will control the Data access permission.
Examples of DCL commands in SQL Server are
- GRANT – It gives users permission o access database.
- REVOKE – This SQL DCL command will withdraw the permission given by GRANT to access the database.
SQL TCL Commands
TCL means Transaction Control Language. These Sql Server TCL commands will control the Transactions.
Examples of TCL commands in SQL Server are
- COMMIT – This SQL TCL command will commit the running transaction
- ROLLBACK – Rollback the current transaction
- SAVEPOINT – You can set a save point so that, next time it will start from here
- SET TRANSACTION – Specify the transactions characteristics