Find in the database all the store procedures using specific tables or views.
Or list all the tables or view, which the specific Views or StoreProcudres use.

EXEC sp_depends @objname='tablename'

Sometime you want to check to see if any StoreProcedures or Views is using specific Views or StoreProcedures

SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%tablename%'

Referece from:
Find Stored Procedure Related to Table in Database – Search in All Stored Procedure

Some more useful articles for you

• Did you know about db4o – a brilliant object oriented database