Back to Trino

SQL statement syntax

docs/src/main/sphinx/sql.md

4801.6 KB
Original Source

SQL statement syntax

This section describes the syntax for SQL statements that can be executed in Trino.

Refer to the following sections for further details:

{toctree}
:maxdepth: 1

sql/alter-branch
sql/alter-materialized-view
sql/alter-schema
sql/alter-table
sql/alter-view
sql/analyze
sql/call
sql/comment
sql/commit
sql/create-branch
sql/create-catalog
sql/create-function
sql/create-materialized-view
sql/create-role
sql/create-schema
sql/create-table
sql/create-table-as
sql/create-view
sql/deallocate-prepare
sql/delete
sql/deny
sql/describe
sql/describe-input
sql/describe-output
sql/drop-branch
sql/drop-catalog
sql/drop-function
sql/drop-materialized-view
sql/drop-role
sql/drop-schema
sql/drop-table
sql/drop-view
sql/execute
sql/execute-immediate
sql/explain
sql/explain-analyze
sql/grant
sql/grant-roles
sql/insert
sql/match-recognize
sql/merge
sql/prepare
sql/refresh-materialized-view
sql/reset-session
sql/reset-session-authorization
sql/revoke
sql/revoke-roles
sql/rollback
sql/select
sql/set-path
sql/set-role
sql/set-session
sql/set-session-authorization
sql/set-time-zone
sql/show-branches
sql/show-catalogs
sql/show-columns
sql/show-create-function
sql/show-create-materialized-view
sql/show-create-schema
sql/show-create-table
sql/show-create-view
sql/show-functions
sql/show-grants
sql/show-role-grants
sql/show-roles
sql/show-schemas
sql/show-session
sql/show-stats
sql/show-tables
sql/start-transaction
sql/truncate
sql/update
sql/use
sql/values
{toctree}
:hidden:

sql/pattern-recognition-in-window