sp_iqunusedtable Procedure

Reports IQ tables that were not referenced by the workload.

Syntax

sp_iqunusedtable

Privileges

Requires the MONITOR system privilege. Users without the MONITOR system privilege must be granted EXECUTE permission to run the stored procedure.

Description

Tables created in SYSTEM and local temporary tables are not reported.

sp_iqunusedtable columns
Column name	Description
TableName	Table name
Owner	User name of table owner

Example

The following table illustrates sample output from the sp_iqunusedtable procedure.

TableName Owner FinancialCodes GROUPO Contacts GROUPO Employees GROUPO emp1 DBA SalesOrders GROUPO FinancialData GROUPO Departments GROUPO SalesOrderItems GROUPO Products GROUP iq_dummy DBA Customers GROUPO sale DBA