Skip to main content

Posts

Showing posts with the label Find Column dependency in SQL Server Store procedure

How To Find Column dependency in SQL Server Store procedure

We can use following queries to find the column dependency in SQL Serve r Store Procedures i.e. Example1, -- THIS QUERY WILL SEARCH IN STORED PROCEDURE ONLY. SELECT DISTINCT OBJECT_NAME ( OBJECT_ID ),             OBJECT_DEFINITION ( OBJECT_ID )             FROM SYS . PROCEDURES WHERE OBJECT_DEFINITION ( OBJECT_ID ) LIKE '%' + 'User_ID' + '%' GO Example 2, -- THIS QUERY WILL SEARCH IN ALL OBJECTS SELECT OBJECT_NAME ( OBJECT_ID ),             DEFINITION             FROM SYS . SQL_MODULES WHERE DEFINITION LIKE '%' + 'User_ID' + '%'             ORDER BY OBJECT_NAME ( OBJECT_ID ) GO
Read more