9. SQL Statement Syntax
This chapter describes the SQL syntax used in Presto.
A reference to the supported SQL data types and other general characteristics is available in a separate chapter.
Advanced users can take it to the next level by using numerous SQL functions and operators.
- 9.1. ALTER SCHEMA
- 9.2. ALTER TABLE
- 9.3. ALTER VIEW
- 9.4. ANALYZE
- 9.5. CALL
- 9.6. COMMENT
- 9.7. COMMIT
- 9.8. CREATE ROLE
- 9.9. CREATE SCHEMA
- 9.10. CREATE TABLE
- 9.11. CREATE TABLE AS
- 9.12. CREATE VIEW
- 9.13. DEALLOCATE PREPARE
- 9.14. DELETE
- 9.15. DESCRIBE
- 9.16. DESCRIBE INPUT
- 9.17. DESCRIBE OUTPUT
- 9.18. DROP ROLE
- 9.19. DROP SCHEMA
- 9.20. DROP TABLE
- 9.21. DROP VIEW
- 9.22. EXECUTE
- 9.23. EXPLAIN
- 9.24. EXPLAIN ANALYZE
- 9.25. GRANT
- 9.26. GRANT ROLES
- 9.27. INSERT
- 9.28. PREPARE
- 9.29. RESET SESSION
- 9.30. REVOKE
- 9.31. REVOKE ROLES
- 9.32. ROLLBACK
- 9.33. SELECT
- 9.34. SET ROLE
- 9.35. SET SESSION
- 9.36. SHOW CATALOGS
- 9.37. SHOW COLUMNS
- 9.38. SHOW CREATE TABLE
- 9.39. SHOW CREATE VIEW
- 9.40. SHOW FUNCTIONS
- 9.41. SHOW GRANTS
- 9.42. SHOW ROLE GRANTS
- 9.43. SHOW ROLES
- 9.44. SHOW SCHEMAS
- 9.45. SHOW SESSION
- 9.46. SHOW STATS
- 9.47. SHOW TABLES
- 9.48. START TRANSACTION
- 9.49. USE
- 9.50. VALUES