13. SQL Statement Syntax

This chapter describes the SQL syntax used in Presto.

A reference to the supported SQL data types and other general characteristics is available in a separate chapter.

Advanced users can take it to the next level by using numerous SQL functions and operators.

• 13.1. ALTER SCHEMA
• 13.2. ALTER TABLE
• 13.3. ALTER VIEW
• 13.4. ANALYZE
• 13.5. CALL
• 13.6. COMMENT
• 13.7. COMMIT
• 13.8. CREATE ROLE
• 13.9. CREATE SCHEMA
• 13.10. CREATE TABLE
• 13.11. CREATE TABLE AS
• 13.12. CREATE VIEW
• 13.13. DEALLOCATE PREPARE
• 13.14. DELETE
• 13.15. DESCRIBE
• 13.16. DESCRIBE INPUT
• 13.17. DESCRIBE OUTPUT
• 13.18. DROP ROLE
• 13.19. DROP SCHEMA
• 13.20. DROP TABLE
• 13.21. DROP VIEW
• 13.22. EXECUTE
• 13.23. EXPLAIN
• 13.24. EXPLAIN ANALYZE
• 13.25. GRANT
• 13.26. GRANT ROLES
• 13.27. INSERT
• 13.28. PREPARE
• 13.29. RESET SESSION
• 13.30. REVOKE
• 13.31. REVOKE ROLES
• 13.32. ROLLBACK
• 13.33. SELECT
• 13.34. SET ROLE
• 13.35. SET SESSION
• 13.36. SHOW CATALOGS
• 13.37. SHOW COLUMNS
• 13.38. SHOW CREATE SCHEMA
• 13.39. SHOW CREATE TABLE
• 13.40. SHOW CREATE VIEW
• 13.41. SHOW FUNCTIONS
• 13.42. SHOW GRANTS
• 13.43. SHOW ROLE GRANTS
• 13.44. SHOW ROLES
• 13.45. SHOW SCHEMAS
• 13.46. SHOW SESSION
• 13.47. SHOW STATS
• 13.48. SHOW TABLES
• 13.49. START TRANSACTION
• 13.50. USE
• 13.51. VALUES