Regatta home page
Search...
⌘K
Ask AI
Support
Start Coding
Start Coding
Search...
Navigation
SQL Syntax Conventions
SQL Syntax Conventions
Docs Home
Quickstart
SQL
Regatta Cloud
Self-Hosted Deployment
Drivers & Clients
Tuning Performance
SQL Specification
Introduction
Data Types
Introduction
Numeric types
Character types
Date/Time types
Boolean types
Type Conversion
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
Join hints
Hints for parallelism of distributed operations
Other hints
SQL Functions and Operators
SQL Functions and Operators
Comparison Functions and Operators
Mathematical Functions and Operators
String Functions and Operators
Date/Time Functions and Operators
Conditional Expressions
Convert Functions
Aggregate Functions
Subquery Expressions
Managing Users
CREATE USER
ALTER USER
DROP USER
System Monitoring
Using System Monitoring Views
SHOW SYSTEM VIEWS
Database Catalog Data
System Catalog Data
Dynamic System Data
System Management
Appendices
Identifiers Limitations
Database Limitations
Reserved Words
SQL Syntax Conventions
SQL Syntax Conventions
The following conventions are used in the synopsis of a command:
brackets
[ ]
indicate optional parts.
Braces
{}
and vertical lines
|
indicate that you must choose one alternative.
Dots
…
mean that the preceding element can be repeated.
**lowercase bold **font indicates a placeholder which should be replaced with an actual value e.g:
table_name
,
parameter_name
, etc.
UPPERCASE COURIER NEW
font indicates SQL language literals (e.g.
SELECT
)
lowercase courier new
font indicates parameter names (e.g.
devices
)
All other symbols, including parentheses, should be taken literally.
Was this page helpful?
Yes
No
ROW IDs
CREATE TABLE
Assistant
Responses are generated using AI and may contain mistakes.