TSQL 查詢Procedure內容

可以用以下指令查詢

 

--列出function/procedure/view物件
--xtype: FU>function, P>Procedure, V>View

SELECT o.name ,o.xtype , c.text FROM SYS.SYSOBJECTS  o
 inner join SYS.SYSCOMMENTS c on o.id =c.id 
WHERE xtype<>'D'  
-- D 是顯示預設值不看
order by xtype

--列出ps_XXXXX procedure
SELECT o.name ,o.xtype , c.text FROM SYS.SYSOBJECTS  o
 inner join SYS.SYSCOMMENTS c on o.id =c.id 
WHERE xtype='P'  
and name = 'ps_XXXXX'

參考

[SQL] 條列 Stored Procedure、Function、View、Trigger