ShowAggregateFunctions

Table of Contents

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

ShowAggregateFunctions()

Name, ReturnType, Parameters and Description. Each prototype is also returned as a message.

Lists the aggregate functions.

EXEC ShowAggregateFunctions

Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.

Shows every lock held by every transaction, optionally for a single process.

Shows the operating system's view of the memory used by the database engine.

Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.

Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.

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

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.

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.