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.