10. SQL Statement Syntax
This chapter describes the SQL syntax used in Presto.
- 10.1. ALTER FUNCTION
- 10.2. ALTER SCHEMA
- 10.3. ALTER TABLE
- 10.4. ANALYZE
- 10.5. CALL
- 10.6. COMMIT
- 10.7. CREATE FUNCTION
- 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 FUNCTION
- 10.19. DROP ROLE
- 10.20. DROP SCHEMA
- 10.21. DROP TABLE
- 10.22. DROP VIEW
- 10.23. EXECUTE
- 10.24. EXPLAIN
- 10.25. EXPLAIN ANALYZE
- 10.26. GRANT
- 10.27. GRANT ROLES
- 10.28. INSERT
- 10.29. PREPARE
- 10.30. RESET SESSION
- 10.31. REVOKE
- 10.32. REVOKE ROLES
- 10.33. ROLLBACK
- 10.34. SELECT
- 10.35. SET ROLE
- 10.36. SET SESSION
- 10.37. SHOW CATALOGS
- 10.38. SHOW COLUMNS
- 10.39. SHOW CREATE FUNCTION
- 10.40. SHOW CREATE TABLE
- 10.41. SHOW CREATE VIEW
- 10.42. SHOW FUNCTIONS
- 10.43. SHOW GRANTS
- 10.44. SHOW ROLE GRANTS
- 10.45. SHOW ROLES
- 10.46. SHOW SCHEMAS
- 10.47. SHOW SESSION
- 10.48. SHOW STATS
- 10.49. SHOW TABLES
- 10.50. START TRANSACTION
- 10.51. USE
- 10.52. VALUES