OmniFabric SQL Reference¶
This section provides a quick reference for SQL available on OmniFabric database instances: structure and syntax, data types, statement categories, functions and operators, system variables and system tables, privilege categories, and capability boundaries.
Use it to find supported syntax and object names. For instance creation, monitoring, alerts, and permissions, see the OmniFabric guide.
OmniFabric SQL follows familiar MySQL 8.0 protocol and syntax conventions while adding vectors, Stage, publication and subscription, snapshots, point-in-time recovery, and other capabilities. These pages summarize the available syntax by topic.
Pages in This Section¶
Page |
Content |
|---|---|
Comments, identifiers, reserved keywords |
|
Numeric, string, time, JSON, VECTOR, and other types |
|
DDL / DML / DQL / DCL / TCL / administrative statement lists |
|
Comprehensive function tables by category |
|
Arithmetic, comparison, logical, bitwise, CAST, CASE/IF, and other operators |
|
Global / session variables and commonly used variables |
|
System databases such as |
|
List of SQL privileges within a tenant |
|
Summary of differences from MySQL, including LOAD DATA and partitioning |
How to Use This Section with the Guides¶
What you want to do |
Where to go |
|---|---|
Create, connect to, monitor, and understand billing for an instance |
|
Configure users and roles in an instance |
|
AI Studio roles and permissions |
|
Run SQL against the Catalog |
SQL Editor (if available) |