Learn With Sundar

    Identifying object dependencies in SQL Server using SP_DEPENDS

    Introduction

    When developing components for SQL Server one change may affect another database object.  Finding these dependent objects should be straightforward, but in most cases it is not as easy as we would think. There are several methods of getting this information, in this article we will have a look using SP_DEPENDS a System Stored Procedure.

    Syntax 

    exec sp_depends [ @objname = ] '<object>'

    The sp_depends  shows the following result set of the object depend on <object>.

    Column nameData typeDescription
    namenvarchar(257 )Name of the item for which a dependency exists.
    typenvarchar(16)Type of the item.

    Example

    exec [sp_depends] @objname = N'[Details].[StudentPersonalDetails]';
    Fig.1 Result set for the example table object

    Conclusion

    By using SP_DEPENDS system stored procedure, we can view all the object dependencies. This is also one of the approach to find the object dependencies. I assume this tip was very useful. Please share your feedback in the comment section.

    Responses

    1. 5 Tips to Improve SQL Query Performance – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    2. Change Schema Name Of Table In MS SQL Server – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    3. Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    4. Multiple Backup Files of the SQL Server database with SSMS and T-SQL – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    5. Recover unsaved SQL queries in SSMS – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    6. Set custom colors to differentiate between environments in SSMS – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    7. Cycle Clipboard Ring In SSMS – Reuse Copied Items – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    8. Customize Azure Data Studio with Dashboard Widgets – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    9. Create and Publish SQL Server Database Project With Visual Studio – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    10. Link a SQL Server Database Project to a Git Repository – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply
    11. Schema Comparisons using Visual Studio SQL Data Tools – Learn With Sundar

      […] Identifying object dependencies in SQL Server using SP_DEPENDS […]

      Like

      Reply

    Leave a reply to Create and Publish SQL Server Database Project With Visual Studio – Learn With Sundar Cancel reply