Keywords



The basis of any query language are the keywords, the major ones are defined here.





























SQL :: Cancel
Cancels transaction associated with a given process.
SQL :: CheckpointHealthCounters
Writes the health counters to disk.
SQL :: ClearCacheAllocations
Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.
SQL :: ClearHealthCounters
Clears the health counters that are tracked by the engine.
SQL :: Count
Tallies the occurrences of a specific field within a given schema.
SQL :: Create Index
Creates an index to speed up read operations.
SQL :: Delete
Delete removes a document from a schema based on a given criteria.
SQL :: Exec
Exec is used to execute a stored procedure (system or user created).
SQL :: Group By
Group by allows you to select a result set and collapse it by a set of given fields.
SQL :: Inner Join
Combines data from two or more tables based on a common field