SQL Statement SyntaxΒΆ
This chapter describes the SQL syntax used in Presto.
- ALTER FUNCTION
- ALTER SCHEMA
- ALTER TABLE
- ANALYZE
- CALL
- COMMIT
- CREATE FUNCTION
- CREATE ROLE
- CREATE SCHEMA
- CREATE TABLE
- CREATE TABLE AS
- CREATE VIEW
- DEALLOCATE PREPARE
- DELETE
- DESCRIBE
- DESCRIBE INPUT
- DESCRIBE OUTPUT
- DROP FUNCTION
- 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 FUNCTION
- 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
- TRUNCATE
- UPDATE
- USE
- VALUES