查询数据库的相关信息

select*
from sysobjects o, syscomments s
where o.id = s.id
AND text like'%V_%'
and o.xtype ='P' or o.xtype='v'

原文地址:https://www.cnblogs.com/zengpeng/p/4424246.html