10. 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.
- 10.1. ALTER SCHEMA
- 10.2. ALTER TABLE
- 10.3. ALTER VIEW
- 10.4. ANALYZE
- 10.5. CALL
- 10.6. COMMENT
- 10.7. COMMIT
- 10.8. CREATE ROLE
- 10.9. CREATE SCHEMA
- 10.10. CREATE TABLE
- 10.11. CREATE TABLE AS
- 10.12. CREATE VIEW
- 10.13. DEALLOCATE PREPARE
- 10.14. DELETE
- 10.15. DESCRIBE
- 10.16. DESCRIBE INPUT
- 10.17. DESCRIBE OUTPUT
- 10.18. DROP ROLE
- 10.19. DROP SCHEMA
- 10.20. DROP TABLE
- 10.21. DROP VIEW
- 10.22. EXECUTE
- 10.23. EXPLAIN
- 10.24. EXPLAIN ANALYZE
- 10.25. GRANT
- 10.26. GRANT ROLES
- 10.27. INSERT
- 10.28. PREPARE
- 10.29. RESET SESSION
- 10.30. REVOKE
- 10.31. REVOKE ROLES
- 10.32. ROLLBACK
- 10.33. SELECT
- 10.34. SET ROLE
- 10.35. SET SESSION
- 10.36. SHOW CATALOGS
- 10.37. SHOW COLUMNS
- 10.38. SHOW CREATE SCHEMA
- 10.39. SHOW CREATE TABLE
- 10.40. SHOW CREATE VIEW
- 10.41. SHOW FUNCTIONS
- 10.42. SHOW GRANTS
- 10.43. SHOW ROLE GRANTS
- 10.44. SHOW ROLES
- 10.45. SHOW SCHEMAS
- 10.46. SHOW SESSION
- 10.47. SHOW STATS
- 10.48. SHOW TABLES
- 10.49. START TRANSACTION
- 10.50. USE
- 10.51. VALUES