create view User_Table_Index_Details as
SELECT     sysobjects.name Table_Name, sysindexes.name AS Indext_Name, sysindexkeys.indid IndexID, sysindexkeys.colid ColID, syscolumns.name AS Colm_Name, syscolumns.xtype, 
                      syscolumns.length
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
where sysobjects.xtype='U'
--order by sysobjects.name,sysindexkeys.indid, sysindexkeys.colid