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

Data Types

Introduction
Character types
Date/Time types
Boolean types
ROW IDs

SQL Syntax Conventions

SQL Syntax Conventions

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

SQL Functions and Operators

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

Managing Users

CREATE USER
ALTER USER
DROP USER

System Monitoring

Using System Monitoring Views
SHOW SYSTEM VIEWS

Appendices

Identifiers Limitations
Database Limitations
Reserved Words

Database Catalog Data

Database Catalog Data

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

The database catalog views maintain information about the database objects (tables, indexes, etc.).

Was this page helpful?

SHOW SYSTEM VIEWS SHOW TABLES

⌘I

Assistant

Responses are generated using AI and may contain mistakes.