sp_iqcolumnmetadata Procedure

Returns details about column indexes in one or more tables.

Syntax

sp_iqcolumnmetadata [ table.name [, owner-name ] ]

Privileges

User must be a table owner, have REFERENCE permissions on the table, or have either the ALTER ANY INDEX or ALTER ANY OBJECT system privilege..

Description

sp_iqcolumnmetadata reads the index metadata to return details about column indexes in both base and global temporary tables. Index metadata reported for a global temporary table is for the individual instance of that table.

Include the optional [table.name] parameter to generate details for that table. Omit the [table.name] parameter to generate details for all tables in the database.