SELECT i.name AS index_name,COL_NAME(ic.object_id, ic.column_id) AS column_name,ic.is_included_column

FROM sys.indexes i INNER JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id WHERE i.object_id = OBJECT_ID('your_table_name');