SELECT DISTINCT A.name, A.xtype
FROM syscomments B
INNER JOIN sysobjects A ON B.id=A.id
WHERE B.TEXT
LIKE '%Employee%'
This will show all SP, Views, Functions, Triggers related to Employee Table.
Loading
SELECT DISTINCT A.name, A.xtype
FROM syscomments B
INNER JOIN sysobjects A ON B.id=A.id
WHERE B.TEXT
LIKE '%Employee%'
This will show all SP, Views, Functions, Triggers related to Employee Table.
Join the conversation! Your thoughts help the community grow.