Search Indxes on Table

This article gives information about Indexes in Database

sp_helpindex :
          It gives information about the indexes on a table or view.

Syntax:
         EXEC sp_helpindex 'Dbo.Table_Name'    

Example:
    EXEC sp_helpindex 'Dbo.Employee_Info'

Result Set displays

                           

        

            ---------------------------------------------------------------------------------------------------------------

 

   

----------------------------------------------------------------------------------------------------------------
  If we create table without primary key then