How to get table schema with there indexes

SELECT       ind.name      ,ind.index_id      ,ic.index_column_id      ,col.name      ,ind.*      ,ic.*      ,col.*  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   WHERE (1=1)      AND ind.is_primary_key = 0      AND ind.is_unique = 0      AND ind.is_unique_constraint = 0      AND t.is_ms_shipped = 0  ORDER BY      t.name, ind.name, ind.index_id, ic.index_column_id 


try this link, hope so
http://stackoverflow.com/questions/765867/list-of-all-index-index-columns-in-sql-server-db