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