Jane
|
How can you find quickly if a string or table name is used in any stored procedure or UDF
Friday, October 05 2018 10:10 AM
How can you find easily if a table name or a field name or any string is used in any stored procedure or user defined function in MS SQL server database?
 reply
|
bthompson
Developer
|
Re:How can you find quickly if a string or table name is used in any stored procedure or UDF
Friday, October 05 2018 10:13 AM
USE [YourDBname];
GO
SELECT [Scehma]=schema_name(o.schema_id), o.Name, o.type
FROM sys.sql_modules m
INNER JOIN sys.objects o
ON o.object_id = m.object_id
WHERE m.definition like '%yourstring%'
GO
reply
|
