ShowSchemaPolicy

Table of Contents

Shows the security policy that applies to a schema: each permission, whether it is granted or denied, and the role and schema it was inherited from.

ShowSchemaPolicy(String schemaName)

Schema, Permission, Rule, InheritedFromRole and InheritedFromSchema.

Shows the policy for a schema.

EXEC ShowSchemaPolicy('WordList:Word')

Lists the built-in scalar functions with their parameters and descriptions.

Lists the built-in system procedures with their parameters and descriptions.

Shows the threads of the engine's thread pools (lookup, indexing, intersection and materialization) and their processor usage.

Shows every active transaction, optionally for a single process.

Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.

Shows the processes that are currently blocked waiting for a lock, optionally for a single process.

Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.

Basic KBSQL syntax and some examples.

Built-in procedures for inspecting and managing the database engine.

Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.