Write a query that returns the dependencies of an object

Question

I'm looking for exactly what Management Studio shows with the "View Dependencies" menu.

1. Management Studio connected to SQL Server 2008
2. Right click on an object and choose "View Dependencies"
3. Now you can navigate through the dependencies back and forth.

How do I get the same information programmatically? (an SQL query?)

Answer 1

Here is another simpler way:

  SELECT DISTINCT
    O.ID ,
    O.Name AS TableName ,
    O.xtype
  FROM
    sysObjects O ( NOLOCK )
  INNER JOIN sysComments C ( NOLOCK ) ON O.ID = C.ID
  WHERE
    C.text LIKE '%<schema_name.function_name>%'
  ORDER BY
    XType ,
    TableName
Before you run the following query, replace <schema_name.function_name> with a valid name