SQL Statement Syntax

This chapter describes the SQL syntax used in Presto.

A reference to the supported SQL data types is available.

Presto also provides numerous SQL functions and operators.

• ALTER SCHEMA
• ALTER TABLE
• ALTER VIEW
• ANALYZE
• CALL
• COMMENT
• COMMIT
• CREATE ROLE
• CREATE SCHEMA
• CREATE TABLE
• CREATE TABLE AS
• CREATE VIEW
• DEALLOCATE PREPARE
• DELETE
• DESCRIBE
• DESCRIBE INPUT
• DESCRIBE OUTPUT
• DROP ROLE
• DROP SCHEMA
• DROP TABLE
• DROP VIEW
• EXECUTE
• EXPLAIN
• EXPLAIN ANALYZE
• GRANT
• GRANT ROLES
• INSERT
• PREPARE
• RESET SESSION
• REVOKE
• REVOKE ROLES
• ROLLBACK
• SELECT
• SET ROLE
• SET SESSION
• SHOW CATALOGS
• SHOW COLUMNS
• SHOW CREATE SCHEMA
• SHOW CREATE TABLE
• SHOW CREATE VIEW
• SHOW FUNCTIONS
• SHOW GRANTS
• SHOW ROLE GRANTS
• SHOW ROLES
• SHOW SCHEMAS
• SHOW SESSION
• SHOW STATS
• SHOW TABLES
• START TRANSACTION
• USE
• VALUES