T-SQL Tutorial

T-SQL Statements - DML and DDL


DDL (Data Definition Language)

Data Definition Language (DDL) statements defines objects in a database. Use DDL statements to create, alter, or drop objects in a database.

CREATE
ALTER
DROP
RENAME
DISABLE TRIGGER
ENABLE TRIGGER
COLLATIONS
UPDATE STATISTICS



DML (Data Manipulation Language)

Data Manipulation Language (DML) affect the information stored in the database. Use DML statements to insert, update, and delete the rows in the database.


INSERT
DELETE
MERGE
BULK INSERT
TRUNCATE TABLE