Hello
select t.name as Tbl_Name ,i.type_desc as Indextype ,c.name as column_name ,ty.name as datatypes,c.max_length as ColumnSize from sys.tables t
JOIn sys.indexes i
ON t.object_id = i.object_id
JOIN sys.index_columns ic
ON ic.object_id = i.object_id
and i.index_id = ic.index_id
JOIN sys.columns c
ON c.object_id = ic.object_id
AND c.column_id = ic.column_id
JOIN sys.types Ty
On c.user_type_id = ty.user_type_id
Pls check it will help you.
Vote if u clear.