CREATE VIEW User_Table_Index_Details
SELECT     sysobjects.name Table_Name, sysindexes.name AS Indext_Name, sysindexkeys.indid IndexID, sysindexkeys.colid ColID, syscolumns.name AS Colm_Name, syscolumns.xtype DataTypeID, 
                       systypes.name AS DataType,syscolumns.length Length_Bytes, syscolumns.prec, syscolumns.scale
FROM         sysobjects INNER JOIN
                      sysindexes ON sysobjects.id = sysindexes.id INNER JOIN
                      sysindexkeys ON sysindexes.id = sysindexkeys.id AND sysindexes.indid = sysindexkeys.indid INNER JOIN
                      syscolumns ON sysindexkeys.id = syscolumns.id AND sysindexkeys.colid = syscolumns.colid INNER JOIN
                      systypes ON syscolumns.xtype = systypes.xtype
where sysobjects.xtype='U'
--order by sysobjects.name,sysindexkeys.indid, syscolumns.colorder,sysindexkeys.colid