查詢哪個表用到的存儲.sql

select distinct name,type,parent=(select name from sysobjects where id=o.parent_obj)from syscomments cjoin sysobjects o on c.id=o.id where text like '%invshzz%'sp_helptext Vinvshzz----查看觸發select * from sysobjects where xtype='TR'