<a id="ksqldb-api-index"></a>

# API Index for ksqlDB for Confluent Platform

This API index lists every SQL statement, function, and operator in
ksqlDB, organized by category, with links to detailed reference pages.

## SQL quick reference

- [SQL Quick Reference](quick-reference.md#ksqldb-reference-quick-reference)

## Functions and operators

- [Aggregate Functions](aggregate-functions.md#ksqldb-reference-aggregate-functions)
- [Operators](operators.md#ksqldb-reference-operators)
- [Scalar Functions](scalar-functions.md#ksqldb-reference-scalar-functions)
- [Table Functions](table-functions.md#ksqldb-reference-table-functions)
- [Type Coercion](type-coercion.md#ksqldb-reference-casting)

## Streams and tables

- [CREATE STREAM AS SELECT](create-stream-as-select.md#ksqldb-reference-create-stream-as-select)
- [CREATE STREAM](create-stream.md#ksqldb-reference-create-stream)
- [CREATE TABLE AS SELECT](create-table-as-select.md#ksqldb-reference-create-table-as-select)
- [CREATE TABLE](create-table.md#ksqldb-reference-create-table)
- [DESCRIBE](describe.md#ksqldb-reference-describe)
- [DROP STREAM](drop-stream.md#ksqldb-reference-drop-stream)
- [DROP TABLE](drop-table.md#ksqldb-reference-drop-table)
- [INSERT INTO](insert-into.md#ksqldb-reference-insert-into)
- [INSERT VALUES](insert-values.md#ksqldb-reference-insert-values)
- [PRINT](print.md#ksqldb-reference-print)

## Queries

- [SELECT (Pull Query)](select-pull-query.md#ksqldb-reference-select-pull-query)
- [SELECT (Push Query)](select-push-query.md#ksqldb-reference-select-push-query)
- [EXPLAIN](explain.md#ksqldb-reference-explain)
- [PAUSE](pause.md#ksqldb-reference-pause)
- [RESUME](resume.md#ksqldb-reference-resume)
- [TERMINATE](terminate.md#ksqldb-reference-terminate)

## Connectors

- [CREATE CONNECTOR](create-connector.md#ksqldb-reference-create-connector)
- [DESCRIBE CONNECTOR](describe-connector.md#ksqldb-reference-describe-connector)
- [DROP CONNECTOR](drop-connector.md#ksqldb-reference-drop-connector)
- [SHOW CONNECTORS](show-connectors.md#ksqldb-reference-show-connectors)

## Custom types

- [CREATE TYPE](create-type.md#ksqldb-reference-create-type)
- [DROP TYPE](drop-type.md#ksqldb-reference-drop-type)
- [SHOW TYPES](show-types.md#ksqldb-reference-show-types)

## Metadata

- [DESCRIBE FUNCTION](describe-function.md#ksqldb-reference-describe-function)
- [SHOW FUNCTIONS](show-functions.md#ksqldb-reference-show-functions)
- [SHOW PROPERTIES](show-properties.md#ksqldb-reference-show-properties)
- [SHOW QUERIES](show-queries.md#ksqldb-reference-show-queries)
- [SHOW STREAMS](show-streams.md#ksqldb-reference-show-streams)
- [SHOW TABLES](show-tables.md#ksqldb-reference-show-tables)
- [SHOW TOPICS](show-topics.md#ksqldb-reference-show-topics)
- [SPOOL](spool.md#ksqldb-reference-spool)

## Execution

- [RUN SCRIPT](run-script.md#ksqldb-reference-run-script)
- [ALTER SYSTEM](alter-system.md#ksqldb-reference-alter-system)

## Assertions

- [ASSERT SCHEMA](assert-schema.md#ksqldb-reference-assert-schema)
- [ASSERT TOPIC](assert-topic.md#ksqldb-reference-assert-topic)