How to find all the dependencies of a table in sql server

by

The following are the ways we can use to check the dependencies:

Method 1: Using sp_depends

 sp_depends 'dbo.First'
 GO

Method 2: Using information_schema.routines

 SELECT *
 FROM information_schema.routines ISR
 WHERE CHARINDEX('dbo.First', ISR.ROUTINE_DEFINITION) > 0
 GO

Method 3: Using DMV sys.dm_sql_referencing_entities

 SELECT referencing_schema_name, referencing_entity_name,
 referencing_id, referencing_class_desc, is_caller_dependent
 FROM sys.dm_sql_referencing_entities ('dbo.First', 'OBJECT');
 GO

More Related Contents:

  1. What do Clustered and Non-Clustered index actually mean?
  2. Regex pattern inside SQL Replace function?
  3. SQL Server Escape an Underscore
  4. How to create materialized views in SQL Server?
  5. Why use the INCLUDE clause when creating an index?
  6. How can I clear the SQL Server query cache?
  7. SQL Server Random Sort
  8. SQL Server database backup restore on lower version
  9. Add a new table column to specific ordinal position in Microsoft SQL Server
  10. Is there a way to simplify a NULL compare of 2 values
  11. An attempt was made to access a socket in a way forbidden by its access permissions
  12. TSQL Try / Catch within Transaction or vice versa?
  13. What is the maximum number of characters that nvarchar(MAX) will hold?
  14. Split one column into multiple rows
  15. #DELETE viewing SQL Server table in Access
  16. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  17. SQL Server (localdb)\v11.0 explained
  18. SQL Server – join rows into comma separated list
  19. Which is quicker COALESCE OR ISNULL?
  20. Merge multiple rows into a single row
  21. “Prevent saving changes that require the table to be re-created” negative effects
  22. How to change column datatype in SQL Server database without losing data?
  23. What are the differences between Merge Join and Lookup transformations in SSIS?
  24. Convert UTC Milliseconds to DATETIME in SQL server
  25. Table Valued Function Killing My Query Performance
  26. freeTDS not using its config
  27. @@ERROR and/or TRY – CATCH
  28. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  29. How to make a passthrough / passthru query editable?
  30. Tool for Scripting Table Data

Leave a Comment