Starburst Enterprise Presto
  • 1. Overview
  • 2. Installation
  • 3. Mission Control
  • 4. Amazon Web Services
  • 5. Kubernetes
  • 6. Security
  • 7. Administration
  • 8. Query Optimizer
  • 9. Connectors
  • 10. Functions and Operators
  • 11. SQL Language
  • 12. SQL Statement Syntax
    • 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
  • 13. Migration
  • 14. Developer Guide
  • 15. Versions
  • 16. Release Notes
  • 404 - Nothing to See Here
Version 332-e.9 LTS and others

Starburst Enterprise Presto 332-e.9 LTS and others
  • Docs »
  • 12. SQL Statement Syntax

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
Next Previous