Query to search table name in SP, Trigger and Views

SELECT DISTINCT so.name,so.xtype

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id=so.id

WHERE sc.TEXT LIKE '%tablename%'