System Queries

System queries are predefined queries that can be used to get information about server objects or the server state.

Data stored in system queries are only meant for reading. You cannot overwrite or append anything to them (e.g. you cannot modify table columns by writing data to the query that returns information).

Names of system queries begin with _IV_. These system queries are as follows:

_IV_LOGGED_USERS - Connected clients and threads
_IV_TABLE_COLUMNS - Table columns in database applications
_IV_INDICIES - A list of table indexes
_IV_CHECK_CONSTRAINS - A list of internal table integrity constraints
_IV_FOREIGN_KEYS - A list of table referential integrity relationships
_IV_PROCEDURE_PARAMETERS - A list of procedure parameters
_IV_LOCKS - A list of locks
_IV_SUBJECT_MEMBERSHIP - A list of privilege subject relationships
_IV_PROFILE - Result of server profiling
_IV_TABLE_SPACE - A space that separate tables occupy in a database file
_IV_MAIL_PROFS - Server mail profiles
_IV_RECENT_LOG - Log entries
_IV_PENDING_LOG_REQS - Log and trace settings
_IV_IP_ADDRESSES - A list of 602SQL Server IP addresses
_IV_MEMORY_USAGE - SQL server memory allocations.

There may be new system queries in future server releases.

List of topics:

System Variables

System Objects

_sysext Scheme