# SQL Reference

## In this section

* [SQL Command Syntax](https://docs.singlestore.com/cloud/reference/sql-reference/sql-command-syntax.md)
* [SQL Commands List](https://docs.singlestore.com/cloud/reference/sql-reference/sql-commands-list.md)
* [SQL Functions List](https://docs.singlestore.com/cloud/reference/sql-reference/sql-functions-list.md)
* [Comparison Operators and Functions](https://docs.singlestore.com/cloud/reference/sql-reference/comparison-operators-and-functions.md)
* [Database Object Case-Sensitivity](https://docs.singlestore.com/cloud/reference/sql-reference/database-object-case-sensitivity.md)
* [Data Types](https://docs.singlestore.com/cloud/reference/sql-reference/data-types.md)
* [Character Encoding](https://docs.singlestore.com/cloud/reference/sql-reference/character-encoding.md)
* [Operations that Take Either a Database or a Workspace Level Lock](https://docs.singlestore.com/cloud/reference/sql-reference/operations-that-take-either-a-database-or-a-workspace-level-lock.md)
* [User-Defined Variables](https://docs.singlestore.com/cloud/reference/sql-reference/user-defined-variables.md)
* [Restricted Keywords](https://docs.singlestore.com/cloud/reference/sql-reference/restricted-keywords.md)
* [Aggregate Functions](https://docs.singlestore.com/cloud/reference/sql-reference/aggregate-functions.md)
* [BSON Functions](https://docs.singlestore.com/cloud/reference/sql-reference/bson-functions.md)
* [Workspace Management Commands](https://docs.singlestore.com/cloud/reference/sql-reference/workspace-management-commands.md)
* [Code Generation Functions](https://docs.singlestore.com/cloud/reference/sql-reference/code-generation-functions.md)
* [Conditional Functions](https://docs.singlestore.com/cloud/reference/sql-reference/conditional-functions.md)
* [Data Definition Language DDL](https://docs.singlestore.com/cloud/reference/sql-reference/data-definition-language-ddl.md)
* [Data Manipulation Language DML](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml.md)
* [Date and Time Functions](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions.md)
* [Distinct Count Estimation Functions](https://docs.singlestore.com/cloud/reference/sql-reference/distinct-count-estimation-functions.md)
* [Full-Text Search Functions](https://docs.singlestore.com/cloud/reference/sql-reference/full-text-search-functions.md)
* [Geospatial Functions](https://docs.singlestore.com/cloud/reference/sql-reference/geospatial-functions.md)
* [Identifier Generation Functions](https://docs.singlestore.com/cloud/reference/sql-reference/identifier-generation-functions.md)
* [Information Functions](https://docs.singlestore.com/cloud/reference/sql-reference/information-functions.md)
* [JSON Functions](https://docs.singlestore.com/cloud/reference/sql-reference/json-functions.md)
* [Numeric Functions](https://docs.singlestore.com/cloud/reference/sql-reference/numeric-functions.md)
* [Operational Commands](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands.md)
* [Pipelines Commands](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands.md)
* [Procedural SQL Reference](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference.md)
* [Regular Expression Functions](https://docs.singlestore.com/cloud/reference/sql-reference/regular-expression-functions.md)
* [Resource Pool Commands](https://docs.singlestore.com/cloud/reference/sql-reference/resource-pool-commands.md)
* [Security Management Commands](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands.md)
* [SHOW Commands](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands.md)
* [String Functions](https://docs.singlestore.com/cloud/reference/sql-reference/string-functions.md)
* [Time Series Functions](https://docs.singlestore.com/cloud/reference/sql-reference/time-series-functions.md)
* [Trace Event Commands](https://docs.singlestore.com/cloud/reference/sql-reference/trace-event-commands.md)
* [Vector Functions](https://docs.singlestore.com/cloud/reference/sql-reference/vector-functions.md)
* [Window Functions](https://docs.singlestore.com/cloud/reference/sql-reference/window-functions.md)

***

Modified at: July 23, 2025

Source: [/cloud/reference/sql-reference/](https://docs.singlestore.com/cloud/reference/sql-reference/)

(An index of the documentation is available at /llms.txt)