Skip to content

Mr SQL's Blog

Musings on Microsoft SQL Server

Tag Archives: sp_helpindex

Simple information about indexes can be found by running

sp_helpindex 'HumanResources.Employee'

where ‘HumanResources.Employee’ is the name of a table. index_name, index_description and index_keys are displayed in the results window:-

sp_helpindex

Tags: , , ,

%d bloggers like this: