SQL Server Dependencies

by

Hopefully I’m not too late with this:

If your SQL Login has access to the sys schema in a particular database, you can use the sys.dependencies view to find all of an object’s dependencies in one shot:

SELECT o.name, o.type_desc, p.name, p.type_desc
FROM sys.sql_dependencies d
INNER JOIN sys.objects o
    ON d.object_id = o.object_id
INNER JOIN sys.objects p
    ON d.referenced_major_id = p.object_id

Using this as a starting point you could probably build a decent tool to create a dependency tree. There are also type specific views (e.g. sys.columns) that give more in depth information regarding each specific database object type; these could be used to provide contextual information on an object if necessary.

More Related Contents:

  1. Export from SQL Server to Excel
  2. hide/remove header and footer
  3. How do I generate a random number for each row in a T-SQL select?
  4. Combine multiple results in a subquery into a single comma-separated value
  5. Infinite loop CTE with OPTION (maxrecursion 0)
  6. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  7. SQL Server: SELECT only the rows with MAX(DATE)
  8. Floor a date in SQL server
  9. LEN function not including trailing spaces in SQL Server
  10. How FOR XML PATH(”) works when concatenating rows
  11. Scheduled run of stored procedure on SQL server
  12. SQL Server ORDER BY date and nulls last
  13. SSRS 2014 report deploy issue
  14. Best way to implement an audit trail in SQL Server?
  15. Set start value for column with autoincrement
  16. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  17. SqlDataAdapter.Fill method slow
  18. What is the Oracle equivalent of SQL Server’s IsNull() function?
  19. syntax for single row MERGE / upsert in SQL Server
  20. How to find all the dependencies of a table in sql server
  21. What happens to the primary key Id when it goes over the limit?
  22. SQL Recursive CTE: Finding objects linked by property
  23. Is there a way to retrieve the view definition from a SQL Server using plain ADO?
  24. T-sql – determine if value is integer
  25. Execute stored procedure with an Output parameter?
  26. Importing excel files having variable headers
  27. What are the differences between Merge Join and Lookup transformations in SSIS?
  28. Table Valued Function Killing My Query Performance
  29. Pivot multiple columns based on one column in SQL Server
  30. How to do Sql Server CE table update from another table

Leave a Comment