sp_iqcolumnmetadata Procedure

Returns details about column indexes in one or more tables.

Syntax

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

Privileges

You must have EXECUTE privilege on the system procedure. You must also have one of the following:

ALTER ANY INDEX system privilege
ALTER ANY OBJECT system privilege
REFERENCE permissions on the table
You own the table

Remarks

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.