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

Managing Users

CREATE USER
ALTER USER
DROP USER

System Monitoring

Using System Monitoring Views
SHOW SYSTEM VIEWS

Appendices

Identifiers Limitations
Database Limitations
Reserved Words

Data Types

Boolean types

Data type	Alias	Size	Ranges
`BOOLEAN`	`BOOL`	1 byte	TRUE or FALSE

Was this page helpful?

Date/Time types Type Conversion

⌘I

Powered by Mintlify

Assistant

Responses are generated using AI and may contain mistakes.