sp_iqunusedcolumn Procedure

Reports IQ columns that were not referenced by the workload.

Syntax

sp_iqunusedcolumn

Privileges

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

Remarks

Columns from tables created in SYSTEM or local temporary tables are not reported.

sp_iqunusedcolumn columns
Column name	Description
TableName	Table name
ColumnName	Column name
Owner	User name of column owner

Example

Sample output from the sp_iqunusedcolumn procedure:

TableName ColumnName Owner SalesOrders ID GROUPO SalesOrders CustomerID GROUPO SalesOrders OrderDate GROUPO SalesOrders FinancialCode GROUPO SalesOrders Region GROUPO SalesOrders SalesRepresentative GROUPO SalesOrderItems ID GROUPO SalesOrderItems LineID GROUPO SalesOrderItems ProductID GROUPO SalesOrderItems Quantity GROUPO SalesOrderItems ShipDate GROUPO Contacts ID GROUPO Contacts Surname GROUPO Contacts GivenName GROUPO ...