The sp_depends shows objects related to the specified object.

Syntax
sp_depends object_name

Sample
sp_depends mytable

Works in Sql Server and Sybase­čśÇ