Posted by adicohn@hotmail.com on 11/17/06 06:15

You can use sp_help TableName which bring you all the information that
you asked for but it also brings back other pieces of information.

You can also use sp_helpindex TableName to bring you only the
information about indexes (including the index that is used by the
primary key).

The unsupported way is to query sysindexes and sysobjects directly.

Adi


frien wrote:
> how do i find primary key, index_name and index_key in the same query
> for a particular table and also want to group by index_name
>
> Thanks

[Back to original message]