- DDL (Data Definition Language): DDL is used to define the structure that holds the data. Examples of DDL commands in MSSQL include CREATE, ALTER, DROP, TRUNCATE, RENAME, and COMMENT. These commands are responsible for creating, modifying, and deleting database objects such as tables, views, indexes, etc.
- DCL (Data Control Language): DCL is used to control access to data within the database. Examples of DCL commands in MSSQL include GRANT and REVOKE. These commands are used to grant or revoke permissions and privileges on database objects to users and roles.
- DML (Data Manipulation Language): DML is used to manage data within database objects. Examples of DML commands in MSSQL include SELECT, INSERT, UPDATE, and DELETE. These commands are used to perform operations on the data stored in tables, such as retrieving data, inserting new records, updating existing records, and deleting records.
- TCL (Transaction Control Language): TCL is used to manage transactions within the database. Examples of TCL commands in MSSQL include COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION, etc. These commands are used to control the transactions, which are a sequence of operations performed as a single logical unit of work, ensuring data consistency and integrity.
- DQL (Data Query Language): DQL is used to retrieve data from the database. In MSSQL, DQL primarily involves the SELECT statement. SELECT statements are used to query the database and retrieve data based on specified criteria.
let me connect to my LinkedIn profile
sameer gaikwad
