Keywords
Table of Contents
The statements and clauses supported by Katzebase, grouped by purpose.
- Select
- Distinct
- Top
- Select Into (SELECT ... INTO)
- Where
- Group By
- Order By (Asc, Desc)
- Offset
- Inner Join
- Outer Join
- Sample
- List
- Create Index
- Create UniqueKey
- Drop Index / Drop UniqueKey
- Rebuild Index / Rebuild UniqueKey
- Analyze Index
- Exec (Execute)
- Kill
- System Procedures
These keywords and options were part of older versions of Katzebase and are no longer supported:
- Create Procedure / Drop Procedure (not currently available)
- PageSize
- Partitions
SQL :: Delete
Delete removes the documents that match the given criteria.
SQL :: Detach Schema
Removes a schema (namespace) from the database and moves its files to a folder.
SQL :: Distinct
Removes duplicate rows from the results of a SELECT.
SQL :: Exec
Exec runs a system procedure.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: GeometricMean
Returns the geometric mean of the values in each group: the nth root of their product. Useful for growth rates and ratios.
SQL :: Group By
Group by collapses a result set into one row per distinct set of values.
SQL :: Inner Join
Combines documents from two or more schemas based on matching fields.
SQL :: Insert
Insert creates new documents in a schema.
SQL :: IsLike
Returns true (1) if the text matches the pattern. The pattern uses the same wildcards as [[Like]]: % matches any number of characters and _ matches a single character.