Starburst Distribution of Presto
312-e.7
  • 1. Overview
  • 2. License and System Requirements
  • 3. Running Presto in a Docker container
  • 4. Presto on Amazon Web Services
  • 5. Presto on Microsoft Azure
  • 6. Presto 312e on Kubernetes
  • 7. Presto RPM Installation using Presto Admin
  • 8. Presto Tarball Installation
  • 9. Presto Client Software
  • 10. Security
  • 11. Administration
  • 12. Query Optimizer
  • 13. Connectors
  • 14. Functions and Operators
  • 15. SQL Language
  • 16. SQL Statement Syntax
    • 16.1. ALTER SCHEMA
    • 16.2. ALTER TABLE
    • 16.3. ANALYZE
    • 16.4. CALL
    • 16.5. COMMENT
    • 16.6. COMMIT
    • 16.7. CREATE ROLE
    • 16.8. CREATE SCHEMA
    • 16.9. CREATE TABLE
    • 16.10. CREATE TABLE AS
    • 16.11. CREATE VIEW
    • 16.12. DEALLOCATE PREPARE
    • 16.13. DELETE
    • 16.14. DESCRIBE
    • 16.15. DESCRIBE INPUT
    • 16.16. DESCRIBE OUTPUT
    • 16.17. DROP ROLE
    • 16.18. DROP SCHEMA
    • 16.19. DROP TABLE
    • 16.20. DROP VIEW
    • 16.21. EXECUTE
    • 16.22. EXPLAIN
    • 16.23. EXPLAIN ANALYZE
    • 16.24. GRANT
    • 16.25. GRANT ROLES
    • 16.26. INSERT
    • 16.27. PREPARE
    • 16.28. RESET SESSION
    • 16.29. REVOKE
    • 16.30. REVOKE ROLES
    • 16.31. ROLLBACK
    • 16.32. SELECT
    • 16.33. SET ROLE
    • 16.34. SET SESSION
    • 16.35. SHOW CATALOGS
    • 16.36. SHOW COLUMNS
    • 16.37. SHOW CREATE TABLE
    • 16.38. SHOW CREATE VIEW
    • 16.39. SHOW FUNCTIONS
    • 16.40. SHOW GRANTS
    • 16.41. SHOW ROLE GRANTS
    • 16.42. SHOW ROLES
    • 16.43. SHOW SCHEMAS
    • 16.44. SHOW SESSION
    • 16.45. SHOW STATS
    • 16.46. SHOW TABLES
    • 16.47. START TRANSACTION
    • 16.48. USE
    • 16.49. VALUES
  • 17. Migration
  • 18. Older Versions
  • 19. Developer Guide
  • 20. Release Notes
Starburst Distribution of Presto
  • Docs »
  • 16. SQL Statement Syntax
  • View page source

16. SQL Statement Syntax

This chapter describes the SQL syntax used in Presto.

  • 16.1. ALTER SCHEMA
  • 16.2. ALTER TABLE
  • 16.3. ANALYZE
  • 16.4. CALL
  • 16.5. COMMENT
  • 16.6. COMMIT
  • 16.7. CREATE ROLE
  • 16.8. CREATE SCHEMA
  • 16.9. CREATE TABLE
  • 16.10. CREATE TABLE AS
  • 16.11. CREATE VIEW
  • 16.12. DEALLOCATE PREPARE
  • 16.13. DELETE
  • 16.14. DESCRIBE
  • 16.15. DESCRIBE INPUT
  • 16.16. DESCRIBE OUTPUT
  • 16.17. DROP ROLE
  • 16.18. DROP SCHEMA
  • 16.19. DROP TABLE
  • 16.20. DROP VIEW
  • 16.21. EXECUTE
  • 16.22. EXPLAIN
  • 16.23. EXPLAIN ANALYZE
  • 16.24. GRANT
  • 16.25. GRANT ROLES
  • 16.26. INSERT
  • 16.27. PREPARE
  • 16.28. RESET SESSION
  • 16.29. REVOKE
  • 16.30. REVOKE ROLES
  • 16.31. ROLLBACK
  • 16.32. SELECT
  • 16.33. SET ROLE
  • 16.34. SET SESSION
  • 16.35. SHOW CATALOGS
  • 16.36. SHOW COLUMNS
  • 16.37. SHOW CREATE TABLE
  • 16.38. SHOW CREATE VIEW
  • 16.39. SHOW FUNCTIONS
  • 16.40. SHOW GRANTS
  • 16.41. SHOW ROLE GRANTS
  • 16.42. SHOW ROLES
  • 16.43. SHOW SCHEMAS
  • 16.44. SHOW SESSION
  • 16.45. SHOW STATS
  • 16.46. SHOW TABLES
  • 16.47. START TRANSACTION
  • 16.48. USE
  • 16.49. VALUES
Next Previous