Get Dependencies of a table

select distinct sd.id, so.name, so.Type, sd.depid, so_dep.name, so_dep.Type

from  sys.sysdepends sd

inner join sys.objects so on so.object_id = sd.id 

and SCHEMA_NAME(so.schema_id) = 'dbo'

inner join sys.objects so_dep on so_dep.object_id = sd.depid 

where so_dep.name = 'TABLENAME'

order by so.name

Understanding SQL Dependencies:

http://msdn.microsoft.com/en-us/library/ms345449.aspx