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 :: Sleep
Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.
SQL :: Sum
Returns the total of the values in each group.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. [[Kill]] does the same thing.
SQL :: Top
The TOP keyword limits the number of results that are returned by a query.
SQL :: TraceWaitTimes
Reports the time spent in each internal operation of a query.
SQL :: Transaction
Transactions make a group of statements all-or-nothing.
SQL :: Update
Update changes fields of existing documents.
SQL :: Variance
Returns the population variance of the values in each group: how far the values are spread from their mean.