Statements

This reference topic summarizes the statements for use with SQL (compatible with T-SQL). You can find all of the documented statements listed in the left-hand navigation.

Data Definition Language

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

  • ALTER
  • CREATE
  • DROP

Data Manipulation Language

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

  • DELETE
  • INSERT
  • UPDATE

Permissions statements

Permissions statements determine which users and logins can access data and perform operations.

Session settings

SET statements determine how the current session handles run time settings. For an overview, see SET statements.