ProgrammerGuide.Net | Step by Step Programmer Guide

Finding Stored Procedures that Accesses Particular Table or Column in SQL Server | SQL Server Tutorial

By querying the Procedures table in Sys as given below, we can find the SQL Server stored procedures that refers particular column are tables.

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrColumnName%'

The result will be the list of SQL Server stored procedure names that refers to particular table or column.

Please click here for related products on Amazon!

Jayashee

Add comment

Want to Check Celebrities News?