Find out Stored Procedure, Views, Functions, Triggers related to a Table

By using this SQL query we can find out all stored procedure, Views, functions, Triggers related to a Table in SQl Server.

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.