viewing index info in query analyzer

30 Sep 2005 2:57 PM

AHIhelp

Does anyone know of a way to get index info on a table within query analyzer?
In the same way that you can run sp_pkeys, sp_columns, sp_tables etc....

--
AHIhelp

30 Sep 2005 3:04 PM

Tibor Karaszi

How about sp_helpindex ? Or use the system tables directly: sysindexes, sysindexkeys, sysobjects.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"AHIhelp" <AHIh***@discussions.microsoft.com> wrote in message
news:39084EA2-3FD5-4E9D-987D-8AED76FD746A@microsoft.com...
> Does anyone know of a way to get index info on a table within query analyzer?
> In the same way that you can run sp_pkeys, sp_columns, sp_tables etc....
> --
> AHIhelp

30 Sep 2005 3:10 PM

Mike Labosh

> Does anyone know of a way to get index info on a table within query
> analyzer?
> In the same way that you can run sp_pkeys, sp_columns, sp_tables etc....

Such as this?

sp_HelpIndex TableName

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane

30 Sep 2005 3:37 PM

Jerry Spivey

Also...check out the Manage Indexes graphical tool in QA. Makes viewing and
managing indexes much easier.

HTH

Jerry
Show quote

"AHIhelp" <AHIh***@discussions.microsoft.com> wrote in message
news:39084EA2-3FD5-4E9D-987D-8AED76FD746A@microsoft.com...
> Does anyone know of a way to get index info on a table within query
> analyzer?
> In the same way that you can run sp_pkeys, sp_columns, sp_tables etc....
> --
> AHIhelp

30 Sep 2005 11:55 PM

ML

Like this?
http://milambda.blogspot.com/2005/09/index-properties-with-kick.html

ML