Keywords

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

• And
• Or
• Like
• Between
• Not

• Insert
• Update
• Delete

• Create Schema
• Alter Schema
• Drop Schema
• Attach Schema
• Detach Schema
• Analyze Schema

• Create Index
• Create UniqueKey
• Drop Index / Drop UniqueKey
• Rebuild Index / Rebuild UniqueKey
• Analyze Index

• Create Account / Drop Account
• Create Role / Alter Role / Drop Role
• Grant / Deny / Revoke

• Begin Transaction
• Commit Transaction
• Rollback Transaction

• Declare
• Set
• Session Variables
• Alter Configuration

• 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