> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Reference

export const Ocient = "Ocient®";

This SQL Reference section includes details about the different data types, functions, and operators available when writing queries for {Ocient}. For an introduction to the general query syntax and working with queries in Ocient, see [Query Ocient](/query-ocient).

For information on the SQL syntax conventions used throughout the Ocient documentation, see the [SQL Syntax Conventions](/sql-syntax-conventions) page.

## **Data Types**

* [Data Types](/data-types)

## **Functions & Operators**

* [Alphabetical SQL Functions List](/alphabetical-sql-functions-list)
* [Categorized SQL Functions List](/categorized-sql-functions-list)
* [Aggregate Functions](/aggregate-functions)
* [Window Aggregate Functions](/window-aggregate-functions)
* [Scalar Data Conversion Functions](/scalar-data-conversion-functions)
* [Date and Time Functions](/date-and-time-functions)
* [Time Zone Functions](/time-zone-functions)
* [Formatting Functions](/formatting-functions)
* [Math Functions and Operators](/math-functions-and-operators)
* [Character and Binary Functions](/character-and-binary-functions)
* [Matrix Functions and Operators](/matrix-functions-and-operators)
* [Tuple Functions and Operators](/tuple-functions-and-operators)
* [Other Functions and Expressions](/other-functions-and-expressions)
* [Array Functions and Operators](/array-functions-and-operators)
* [HyperLogLog Functions](/hyperloglog-functions)
* [Network Type Functions](/network-type-functions)

## **Geospatial Functions & Operators**

* [Attribute Functions](/attribute-functions)
* [Conversion Functions](/conversion-functions)
* [Linestring Functions](/linestring-functions)
* [Linestring Constructors](/linestring-constructors)
* [Point Constructors](/point-constructors)
* [Polygon Constructors](/polygon-constructors)
* [Spatial Measurement](/spatial-measurement)
* [Spatial Operators](/spatial-operators)
* [Spatial Relationships](/spatial-relationships)
* [Spatiotemporal Measurement](/spatiotemporal-measurement)
* [Spatiotemporal Operators](/spatiotemporal-operators)

## **DDL SQL Statements**

* [Cluster and Node Management](/cluster-and-node-management)
* [Databases](/databases)
* [Schemas](/schemas)
* [Tables](/tables)
* [Views](/views)
* [Indexes](/indexes)
* [Data Pipelines](/data-pipelines)
* [Distributed Tasks](/distributed-tasks)
* [Machine Learning Models](/machine-learning-models)
* [Users, Groups, and Service Classes](/users-groups-and-service-classes)
* [Data Integrity and Storage](/data-integrity-and-storage)
* [Query Analysis](/query-analysis)
* [Query Management](/query-management)
* [Statistics Cache Management](/statistics-cache-management)

## **DCL SQL Statements**

* [Data Control Language (DCL) Statement Reference](/data-control-language-dcl-statement-reference)

## **DML SQL Statements**

* [Data Manipulation Language (DML) Statement Reference](/data-manipulation-language-dml-statement-reference)

## **DQL SQL Statements**

* [Data Query Language (DQL) Statement Reference](/data-query-language-dql-statement-reference)
* [Join Operations](/join-operations)
* [SQL Syntax Conventions](/sql-syntax-conventions)
* [Identifiers](/identifiers)
* [Generate Tables Using sys.dummy](/generate-tables-using-sys-dummy)

## **TCL SQL Statements**

* [Transactional Control Language (TCL) Statement Reference](/transaction-control-language-tcl-statement-reference)

## **Machine Learning Execution**

* [Machine Learning Model Functions](/machine-learning-model-functions)
* [Data Preparation](/data-preparation)
* [Machine Learning Model Options](/machine-learning-model-options)

## **Other SQL Reference**

* [Errors and Warnings](/errors-and-warnings)
* [Data Pipeline Loading Errors](/data-pipeline-loading-errors)
* [Reserved Words](/reserved-words)
* [System Catalog Reference](/system-catalog-reference)
* [System Catalog](/system-catalog)
* [Information Schema](/information-schema)