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

Skip to main content

Regatta home page

Support
Start Coding
Start Coding

Docs Home
Quickstart
SQL
Regatta Cloud
Self-Hosted Deployment
Drivers & Clients
Tuning Performance

SQL Specification

Introduction

SQL Syntax Conventions

SQL Syntax Conventions

Data Types

Introduction
Character types
Date/Time types
Boolean types
UUID type
ROW IDs

SQL Functions and Operators

SQL Functions and Operators
Comparison Functions and Operators
String Functions and Operators
Date/Time Functions and Operators
UUID Functions and Operators

Data Definition Language (DDL) Commands

CREATE TABLE
ALTER TABLE
DROP TABLE

Data Manipulation Language Commands

INSERT
UPDATE
DELETE

Transaction Control Language Commands

Transaction Control Language Commands
SET TRANSACTION

Data Query Language

SELECT
EXPLAIN

Hints

Overview
General notes

Managing Users

CREATE USER
ALTER USER
DROP USER

System Monitoring

Using System Monitoring Views
SHOW SYSTEM VIEWS

System Management

System States and Commands
Nodes
Modules
Storage Devices
System Manager

Appendices

Identifiers Limitations
Database Limitations
Reserved Words

Vector Index

Introduction
Show Commands
Performing Approximate Vector Searches

Data Types

Introduction

This section lists all the data types supported by Regatta.

Was this page helpful?

SQL Syntax Conventions

Exact numeric data type

Assistant

Responses are generated using AI and may contain mistakes.