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 :: Set
Set changes a session variable.
SQL :: Sha1Agg
Returns a single SHA-1 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: Sha256Agg
Returns a single SHA-256 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: Sha512Agg
Returns a single SHA-512 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: ShowBlocks
Shows which process is blocking each blocked process, optionally for a single process.
SQL :: ShowBlockTree
Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.
SQL :: ShowHealthCounters
Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.
SQL :: ShowLocks
Shows every lock held by every transaction, optionally for a single process.
SQL :: ShowMemoryUtilization
Shows the operating system's view of the memory used by the database engine.