-
Data Definition Language (DDL) Statements
Data Definition Language (DDL) is a vocabulary used to define data structures . Use these statements to create, alter, or drop data structures in an instance of SQL Server.
ALTER Statements (Transact-SQL)
CREATE Statements (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
DROP Statements (Transact-SQL)
UPDATE STATISTICS (Transact-SQL)
-
Data Manipulation Language (DML) Statements
Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data . Use these statements to add, modify, query, or remove data from a SQL Server database.
The following table lists the DML statements that SQL Server uses.
The following table lists the clauses that are used in multiple DML statements or clauses.
| Clause | Can be used in these statements |
|---|---|
| FROM (Transact-SQL) | DELETE, SELECT, UPDATE |
| Hints (Transact-SQL) | DELETE, INSERT, SELECT, UPDATE |
| OPTION Clause (Transact-SQL) | DELETE, SELECT, UPDATE |
| OUTPUT Clause (Transact-SQL) | DELETE, INSERT, MERGE, UPDATE |
| Search Condition (Transact-SQL) | DELETE, MERGE, SELECT, UPDATE |
| Table Value Constructor (Transact-SQL) | FROM, INSERT, MERGE |
| TOP (Transact-SQL) | DELETE, INSERT, MERGE, SELECT, UPDATE |
| WHERE (Transact-SQL) | DELETE, SELECT, UPDATE |
| WITH common_table_expression (Transact-SQL) | DELETE, INSERT, MERGE, SELECT, UPDATE |
https://msdn.microsoft.com/en-us/library/ff848766.aspx