ShowLocks

Table of Contents



Shows all locks, what type of lock and the object which has been locked. Optionally specifying a process id to filter by.


round-pushpin Shows the locks for all processes.
Exec ShowLocks

round-pushpin Shows the locks for the process id 1.
Exec ShowLocks 1




SQL::ShowSystemFunctions
Displays the list of built-in system functions and their parameters.
SQL::System Procedures
Built in procedures that allow you to evaluate various aspect of the database engine.