9. SQL Statement Syntax
This chapter describes the SQL syntax used in Presto.
- 9.1. ALTER SCHEMA
- 9.2. ALTER TABLE
- 9.3. ANALYZE
- 9.4. CALL
- 9.5. COMMENT
- 9.6. COMMIT
- 9.7. CREATE ROLE
- 9.8. CREATE SCHEMA
- 9.9. CREATE TABLE
- 9.10. CREATE TABLE AS
- 9.11. CREATE VIEW
- 9.12. DEALLOCATE PREPARE
- 9.13. DELETE
- 9.14. DESCRIBE
- 9.15. DESCRIBE INPUT
- 9.16. DESCRIBE OUTPUT
- 9.17. DROP ROLE
- 9.18. DROP SCHEMA
- 9.19. DROP TABLE
- 9.20. DROP VIEW
- 9.21. EXECUTE
- 9.22. EXPLAIN
- 9.23. EXPLAIN ANALYZE
- 9.24. GRANT
- 9.25. GRANT ROLES
- 9.26. INSERT
- 9.27. PREPARE
- 9.28. RESET SESSION
- 9.29. REVOKE
- 9.30. REVOKE ROLES
- 9.31. ROLLBACK
- 9.32. SELECT
- 9.33. SET ROLE
- 9.34. SET SESSION
- 9.35. SHOW CATALOGS
- 9.36. SHOW COLUMNS
- 9.37. SHOW CREATE TABLE
- 9.38. SHOW CREATE VIEW
- 9.39. SHOW FUNCTIONS
- 9.40. SHOW GRANTS
- 9.41. SHOW ROLE GRANTS
- 9.42. SHOW ROLES
- 9.43. SHOW SCHEMAS
- 9.44. SHOW SESSION
- 9.45. SHOW STATS
- 9.46. SHOW TABLES
- 9.47. START TRANSACTION
- 9.48. USE
- 9.49. VALUES