12. 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.
- 12.1. ALTER SCHEMA
- 12.2. ALTER TABLE
- 12.3. ALTER VIEW
- 12.4. ANALYZE
- 12.5. CALL
- 12.6. COMMENT
- 12.7. COMMIT
- 12.8. CREATE ROLE
- 12.9. CREATE SCHEMA
- 12.10. CREATE TABLE
- 12.11. CREATE TABLE AS
- 12.12. CREATE VIEW
- 12.13. DEALLOCATE PREPARE
- 12.14. DELETE
- 12.15. DESCRIBE
- 12.16. DESCRIBE INPUT
- 12.17. DESCRIBE OUTPUT
- 12.18. DROP ROLE
- 12.19. DROP SCHEMA
- 12.20. DROP TABLE
- 12.21. DROP VIEW
- 12.22. EXECUTE
- 12.23. EXPLAIN
- 12.24. EXPLAIN ANALYZE
- 12.25. GRANT
- 12.26. GRANT ROLES
- 12.27. INSERT
- 12.28. PREPARE
- 12.29. RESET SESSION
- 12.30. REVOKE
- 12.31. REVOKE ROLES
- 12.32. ROLLBACK
- 12.33. SELECT
- 12.34. SET ROLE
- 12.35. SET SESSION
- 12.36. SHOW CATALOGS
- 12.37. SHOW COLUMNS
- 12.38. SHOW CREATE TABLE
- 12.39. SHOW CREATE VIEW
- 12.40. SHOW FUNCTIONS
- 12.41. SHOW GRANTS
- 12.42. SHOW ROLE GRANTS
- 12.43. SHOW ROLES
- 12.44. SHOW SCHEMAS
- 12.45. SHOW SESSION
- 12.46. SHOW STATS
- 12.47. SHOW TABLES
- 12.48. START TRANSACTION
- 12.49. USE
- 12.50. VALUES