Terminate



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

Terminate(Numeric processId)

Permissions

Requires an account that is a member of an administrator role.


round-pushpin Terminates process 100.
EXEC Terminate(100)




API :: Client
Using the NTDLS.Katzebase.Api client library from .NET.
Home
The home page
SQL :: Alter Procedure
User-defined stored procedures are not currently available.
SQL :: Cancel
Cancels (rolls back) the transaction of the given process, leaving the process connected.
SQL :: CheckpointHealthCounters
Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.
SQL :: ClearCacheAllocations
Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.
SQL :: ClearHealthCounters
Resets the health counters tracked by the engine. This is helpful when performance tuning.
SQL :: Exec
Exec runs a system procedure.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Kill
Terminates a process.