SQL Server to view indexes on a table

Method: 1

Sys.indexes

index_id = 0: Heap

index_id = 1: Clustered index

index_id =2 ...: Nonclustered indexes

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

Example:

CREATE TABLE Student (
ID int NOT NULL,
Name nvarchar (16),
Major nvarchar (16));
Go

CREATE INDEX ix_for_student_id
On Dbo.student (ID);
Go

Create clustered Index Ix_clu_for_student_name
ON dbo. Student (Name);
Go

Select object_name (ix.object_id), ix.index_id,ix.name from Sys.indexes as IX
where ix.object_id = object_id (' Student ');
Go

SQL Server to view indexes on a table