Get Indexes in SQL Server

Use below query to get Indexes in the SQL Server

SELECT 
ind.name 
,ind.index_id 
,ic.index_column_id 
,col.name
,t.name 
FROM sys.indexes ind 

INNER JOIN sys.index_columns ic 
ON  ind.object_id = ic.object_id and ind.index_id = ic.index_id 

INNER JOIN sys.columns col 
ON ic.object_id = col.object_id and ic.column_id = col.column_id 

INNER JOIN sys.tables t 
ON ind.object_id = t.object_id 

ORDER BY 
t.name, ind.name, ind.index_id, ic.index_column_id