Reports IQ columns that were not referenced by the workload.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Columns from tables created in SYSTEM or local temporary tables are not reported.
Column name |
Description |
|---|---|
TableName |
Table name |
ColumnName |
Column name |
Owner |
User name of column owner |
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 ...