Finding indexes on MS SQL Server

In order to find indexes either clustered or non-clustered on MS SQL server , we can use this script to find the associated index to a Table or View.

EXEC sp_helpindex N'dbo.tblCustomer';
Advertisements