17. SQL Statement Syntax

This chapter describes the SQL syntax used in Presto.

• 17.1. ALTER SCHEMA
• 17.2. ALTER TABLE
• 17.3. CALL
• 17.4. COMMIT
• 17.5. CREATE ROLE
• 17.6. CREATE SCHEMA
• 17.7. CREATE TABLE
• 17.8. CREATE TABLE AS
• 17.9. CREATE VIEW
• 17.10. DEALLOCATE PREPARE
• 17.11. DELETE
• 17.12. DESCRIBE
• 17.13. DESCRIBE INPUT
• 17.14. DESCRIBE OUTPUT
• 17.15. DROP ROLE
• 17.16. DROP SCHEMA
• 17.17. DROP TABLE
• 17.18. DROP VIEW
• 17.19. EXECUTE
• 17.20. EXPLAIN
• 17.21. EXPLAIN ANALYZE
• 17.22. GRANT
• 17.23. GRANT ROLES
• 17.24. INSERT
• 17.25. PREPARE
• 17.26. RESET SESSION
• 17.27. REVOKE
• 17.28. REVOKE ROLES
• 17.29. ROLLBACK
• 17.30. SELECT
• 17.31. SET ROLE
• 17.32. SET SESSION
• 17.33. SHOW CATALOGS
• 17.34. SHOW COLUMNS
• 17.35. SHOW CREATE TABLE
• 17.36. SHOW CREATE VIEW
• 17.37. SHOW FUNCTIONS
• 17.38. SHOW GRANTS
• 17.39. SHOW PARTITIONS
• 17.40. SHOW ROLE GRANTS
• 17.41. SHOW ROLES
• 17.42. SHOW SCHEMAS
• 17.43. SHOW SESSION
• 17.44. SHOW TABLES
• 17.45. START TRANSACTION
• 17.46. USE
• 17.47. VALUES