8. SQL Statement Syntax

This chapter describes the SQL syntax used in Presto.

• 8.1. ALTER SCHEMA
• 8.2. ALTER TABLE
• 8.3. ANALYZE
• 8.4. CALL
• 8.5. COMMIT
• 8.6. CREATE ROLE
• 8.7. CREATE SCHEMA
• 8.8. CREATE TABLE
• 8.9. CREATE TABLE AS
• 8.10. CREATE VIEW
• 8.11. DEALLOCATE PREPARE
• 8.12. DELETE
• 8.13. DESCRIBE
• 8.14. DESCRIBE INPUT
• 8.15. DESCRIBE OUTPUT
• 8.16. DROP ROLE
• 8.17. DROP SCHEMA
• 8.18. DROP TABLE
• 8.19. DROP VIEW
• 8.20. EXECUTE
• 8.21. EXPLAIN
• 8.22. EXPLAIN ANALYZE
• 8.23. GRANT
• 8.24. GRANT ROLES
• 8.25. INSERT
• 8.26. PREPARE
• 8.27. RESET SESSION
• 8.28. REVOKE
• 8.29. REVOKE ROLES
• 8.30. ROLLBACK
• 8.31. SELECT
• 8.32. SET ROLE
• 8.33. SET SESSION
• 8.34. SHOW CATALOGS
• 8.35. SHOW COLUMNS
• 8.36. SHOW CREATE TABLE
• 8.37. SHOW CREATE VIEW
• 8.38. SHOW FUNCTIONS
• 8.39. SHOW GRANTS
• 8.40. SHOW ROLE GRANTS
• 8.41. SHOW ROLES
• 8.42. SHOW SCHEMAS
• 8.43. SHOW SESSION
• 8.44. SHOW STATS
• 8.45. SHOW TABLES
• 8.46. START TRANSACTION
• 8.47. USE
• 8.48. VALUES