16. SQL Statement Syntax

This chapter describes the SQL syntax used in Presto.

• 16.1. ALTER SCHEMA
• 16.2. ALTER TABLE
• 16.3. ANALYZE
• 16.4. CALL
• 16.5. COMMENT
• 16.6. COMMIT
• 16.7. CREATE ROLE
• 16.8. CREATE SCHEMA
• 16.9. CREATE TABLE
• 16.10. CREATE TABLE AS
• 16.11. CREATE VIEW
• 16.12. DEALLOCATE PREPARE
• 16.13. DELETE
• 16.14. DESCRIBE
• 16.15. DESCRIBE INPUT
• 16.16. DESCRIBE OUTPUT
• 16.17. DROP ROLE
• 16.18. DROP SCHEMA
• 16.19. DROP TABLE
• 16.20. DROP VIEW
• 16.21. EXECUTE
• 16.22. EXPLAIN
• 16.23. EXPLAIN ANALYZE
• 16.24. GRANT
• 16.25. GRANT ROLES
• 16.26. INSERT
• 16.27. PREPARE
• 16.28. RESET SESSION
• 16.29. REVOKE
• 16.30. REVOKE ROLES
• 16.31. ROLLBACK
• 16.32. SELECT
• 16.33. SET ROLE
• 16.34. SET SESSION
• 16.35. SHOW CATALOGS
• 16.36. SHOW COLUMNS
• 16.37. SHOW CREATE TABLE
• 16.38. SHOW CREATE VIEW
• 16.39. SHOW FUNCTIONS
• 16.40. SHOW GRANTS
• 16.41. SHOW ROLE GRANTS
• 16.42. SHOW ROLES
• 16.43. SHOW SCHEMAS
• 16.44. SHOW SESSION
• 16.45. SHOW STATS
• 16.46. SHOW TABLES
• 16.47. START TRANSACTION
• 16.48. USE
• 16.49. VALUES