find columns and tables in a view

 

SELECT  vObj.name AS vName, vObj.id AS vID, vObj.xtype AS vType,

          dep.depid, dep.depnumber, tObj.name AS tName, col.colid,

          col.name AS cName

FROM         sysobjects vObj LEFT OUTER JOIN

             sysdepends dep ON vObj.id = dep.id LEFT OUTER JOIN

             sysobjects tObj ON dep.depid = tObj.id LEFT OUTER JOIN

             syscolumns col ON dep.depnumber = col.colid

                   AND tObj.id = col.id

WHERE   vObj.xtype = 'V' And vObj.category = 0

and   vObj.name = 'vw1_inv_item_det'

ORDER BY vObj.name, tObj.name, col.name