sp_iqtableuse Procedure

Reports detailed usage information for tables accessed by the workload.

Syntax

sp_iqtableuse

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

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