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:
Running SQL queries
SQL queries can be run against FeatureBase tables in the following ways:
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 ]
View history
System tables contain a history of queries and other information
History required | Query |
---|---|
Database metrics | SELECT * FROM fb_performance_counters; |
Query log | SELECT * FROM fb_exec_requests; |
Statements
Functions
Data types
Operators
Expressions
System Tables
Further information
Table of contents
- Statements
- SQL hints
- Data types & constraints
- Functions
- Expressions
- Operators
- SQL examples
- FeatureBase SQL issues
- FeatureBase system tables