Introduction:
Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.
Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.
Description:
In
previous articles I explained find hierarchical data in sql server, cursor example in sql server, joins in sql server, function example in sql server 2008, Primary key constraint in sql
server,
foreign key constraint in sql
server,
query to remove first and last
characters from string in sql server and
many articles relating to SQL
server.
Now I will explain difference between DDL, DML, DCL and TCL statements in sql
server.