Statements

Statements#

This reference topic summarizes the Transact-SQL statements Querona supports, grouped below. Each group links to its own reference.

Data Definition Language#

DDL statements define and change data structures — CREATE, ALTER and DROP for databases, schemas, tables, views, indexes and more.

Data Manipulation Language#

DML statements add, change and remove the rows in tables and views — INSERT, UPDATE, DELETE, MERGE and TRUNCATE.

Permissions#

Data Control Language (DCL) manages permissions on objects — GRANT, DENY and REVOKE.

Sessions and transactions#

  • SET statements control run-time settings for the current session.

  • Transactions group statements with BEGIN / COMMIT / ROLLBACK.

  • USE switches the current database.

Other statements#