You should review all the options of these commands in the SQL Server books (BOL) especially when upgrading to a new version of SQL Sever.
1 – DDL – Data Definition Language commands are used to manage schema objects like databases, tables, triggers.
ALTER
CREATE
DISABLE TRIGGER
DROP
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
2 – DML – Data Manipulation language commands are used to manage data.
BULK INSERT
DELETE
INSERT
MERGE
SELECT
TRUNCATE TABLE
UPDATE
3 – DCL – Data control language commands are used to manage security permissions.
GRANT
REVOKE