Get Index Properties

select top 100 
		s.name [Schema],
		o.name [Object],
		o.type_desc [ObjectType],
		i.name [Index],
		i.type [IndexType],
		i.index_id [IndexID],
		INDEXPROPERTY(o.object_id,i.name,'IndexDepth') AS [IndexDepth],
		INDEXPROPERTY(o.object_id,i.name,'IndexDepth') AS [IndexDepth],
		INDEXPROPERTY(o.object_id,i.name,'IndexFillFactor') AS [IndexFillFactor],
		INDEXPROPERTY(o.object_id,i.name,'IsAutoStatistics') AS [IsAutoStatistics],
		INDEXPROPERTY(o.object_id,i.name,'IsClustered') AS [IsClustered],
		INDEXPROPERTY(o.object_id,i.name,'IsDisabled') AS [IsDisabled],
		INDEXPROPERTY(o.object_id,i.name,'IsFulltextKey') AS [IsFulltextKey],
		INDEXPROPERTY(o.object_id,i.name,'IsHypothetical') AS [IsHypothetical],
		INDEXPROPERTY(o.object_id,i.name,'IsPadIndex') AS [IsPadIndex],
		INDEXPROPERTY(o.object_id,i.name,'IsPageLockDisallowed') AS [IsPageLockDisallowed],
		INDEXPROPERTY(o.object_id,i.name,'IsRowLockDisallowed') AS [IsRowLockDisallowed],
		INDEXPROPERTY(o.object_id,i.name,'IsStatistics') AS [IsStatistics],
		INDEXPROPERTY(o.object_id,i.name,'IsUnique') AS [IsUnique],
		INDEXPROPERTY(o.object_id,i.name,'IsColumnstore') AS [IsColumnstore],
		INDEXPROPERTY(o.object_id,i.name,'IsOptimizedForSequentialKey') AS [IsOptimizedForSequentialKey]
		-- ,* 
from sys.objects o
inner join sys.schemas s on s.schema_id = o.schema_id
inner join sys.indexes i on i.object_id = o.object_id
where o.is_ms_shipped = 0
and i.index_id > 0
-- and o.name = '<table>'
-- and s.name = 'dbo'
ORDER BY [Schema], [Object], [IndexID]