Statement Index

SQL Quick Reference

• SQL Quick Reference

Functions and Operators

• Aggregate Functions
• Operators
• Scalar Functions
• Table Functions
• Type Coercion

Streams and Tables

• CREATE STREAM AS SELECT
• CREATE STREAM
• CREATE TABLE AS SELECT
• CREATE TABLE
• DESCRIBE
• DROP STREAM
• DROP TABLE
• INSERT INTO
• INSERT VALUES
• PRINT

Queries

• SELECT (Pull Query)
• SELECT (Push Query)
• EXPLAIN
• PAUSE
• RESUME
• TERMINATE

Connectors

• CREATE CONNECTOR
• DESCRIBE CONNECTOR
• DROP CONNECTOR
• SHOW CONNECTORS

Custom Types

• CREATE TYPE
• DROP TYPE
• SHOW TYPES

Metadata

• DESCRIBE FUNCTION
• SHOW FUNCTIONS
• SHOW PROPERTIES
• SHOW QUERIES
• SHOW STREAMS
• SHOW TABLES
• SHOW TOPICS
• SPOOL

Execution

• RUN SCRIPT
• ALTER SYSTEM

Assertions

• ASSERT SCHEMA
• ASSERT TOPIC

---

Last update: 2024-10-28