查詢資料庫裡的預存程序、函數、視圖

-- ==========================================-- Author     : 樞木-- date       : -- Description: 查詢資料庫裡的預存程序、函數、視圖-- ==========================================/* typetype_desc -------------------------- FNSQL_SCALAR_FUNCTION P SQL_STORED_PROCEDURE V VIEW**/DECLARE @definition varchar(50)DECLARE @type varchar(50)SET @definition='關鍵字'SET @type='P'SELECT o.name,m.definition,o.type_descFROM sys.objects o,sys.sql_modules m WHERE o.object_id=m.object_id   and o.type=@type  and m.definition like '%'+@definition+'%'