sp_iqtableuse Procedure

Reports detailed usage information for tables accessed by the workload.

Syntax

sp_iqtableuse

Privileges

You must have EXECUTE privilege on the system procedure, as well as the MONITOR system privilege.

Remarks

Tables created in SYSTEM are not reported.

sp_iqtableuse columns

Column name

Description

TableName

Table name

Owner

User name of table owner

UID**

Table unique identifier

LastDT

Date/time of last access

NRef

Number of query references

**UID is a number assigned by the system that uniquely identifies the instance of the table (where instance is defined when an object is created).

Related reference
sp_iqcolumnuse Procedure
sp_iqindexadvice Procedure
sp_iqindexuse Procedure
sp_iqunusedcolumn Procedure
sp_iqunusedindex Procedure
sp_iqunusedtable Procedure
sp_iqworkmon Procedure
Determining the Security Model Used by a Database