List tables,stored procs & Scrips

,

list all user tables,stored procedures involving these tabels and the scrips of these procedures

SELECT C.NAME [Table], A.NAME [Procedure] ,B.TEXT Script FROM SYSOBJECTS A, SYSCOMMENTS B,SYSOBJECTS C WHERE  B.TEXT LIKE '%PROC% '+C.NAME+' %' AND A.ID = B.ID AND C.TYPE='U' AND C.NAME<>'DTPROPERTIES'

Rate

Share

Share

Rate