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