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 :: QueryThreadWeight
Removed: QueryThreadWeight is no longer a session variable.
SQL :: ReadUncommitted
Reads without waiting for other transactions' locks.
SQL :: Rebuild Index
Rebuilds an index from the documents in its schema.
SQL :: RefreshMyRoles
Reloads the role memberships of the logged in account. Roles are cached at login, so run this after your memberships change instead of logging out and back in. The roles are returned as messages.
SQL :: ReleaseCacheAllocations
Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.
SQL :: Sample
Returns a random sample of documents from a schema.
SQL :: Security Policy
Accounts, roles, memberships and schema permissions.
SQL :: Select
Select statements are used to read (or query) data from the database.
SQL :: Select Into
Creates a schema and fills it with the results of a SELECT.
SQL :: Session Variables
Settings that are scoped to the connected session.