FeatureBase SQL guide
FeatureBase supports different types of queries that are discussed further in the following reference pages.
Table of contents
Before you begin
Create a FeatureBase database using one of the following methods:
A database is automatically created when you Install FeatureBase Community
Running SQL queries
SQL queries can be run against FeatureBase tables in the following ways:
| Application | API | CLI | GUI |
|---|---|---|---|
| Cloud | Cloud API | CLI fbsql tool | Cloud GUI query editor |
| Community | Community API | CLI fbsql tool | Community GUI query editor |
Syntax notation
KEYWORD
<variable or element>
<alternative> | <alternative2>
<repeat element until indicated>...
<repeat element separated by commas until indicated>,...
{ required elements }
( required parenthesis )
[ optional elements ]
Statements
Functions
Data types
Operators
Expressions
System Tables
Table of contents
- Statements
- SQL hints
- Data types & constraints
- Functions
- Expressions
- Operators
- SQL examples
- FeatureBase system tables