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 SCHEMA
• 17.6. CREATE TABLE
• 17.7. CREATE TABLE AS
• 17.8. CREATE VIEW
• 17.9. DEALLOCATE PREPARE
• 17.10. DELETE
• 17.11. DESCRIBE
• 17.12. DESCRIBE INPUT
• 17.13. DESCRIBE OUTPUT
• 17.14. DROP SCHEMA
• 17.15. DROP TABLE
• 17.16. DROP VIEW
• 17.17. EXECUTE
• 17.18. EXPLAIN
• 17.19. EXPLAIN ANALYZE
• 17.20. GRANT
• 17.21. INSERT
• 17.22. PREPARE
• 17.23. RESET SESSION
• 17.24. REVOKE
• 17.25. ROLLBACK
• 17.26. SELECT
• 17.27. SET SESSION
• 17.28. SHOW CATALOGS
• 17.29. SHOW COLUMNS
• 17.30. SHOW CREATE TABLE
• 17.31. SHOW CREATE VIEW
• 17.32. SHOW FUNCTIONS
• 17.33. SHOW GRANTS
• 17.34. SHOW PARTITIONS
• 17.35. SHOW SCHEMAS
• 17.36. SHOW SESSION
• 17.37. SHOW TABLES
• 17.38. START TRANSACTION
• 17.39. USE
• 17.40. VALUES