sp_depends lists all the objects that the view or table references in the current database, and all the objects that reference that view or table.
sp_depends titles
Things inside the current database that reference the object. object type ------------- --------------------------- dbo.history_proc stored procedure dbo.title_proc stored procedure dbo.titleid_proc stored procedure dbo.deltitle trigger dbo.totalsales_trig trigger dbo.accounts view dbo.bookview view dbo.categories view dbo.hiprice view dbo.multitable_view view dbo.titleview view (return status = 0)
