SQL – Search for Table Name

This is a query to search for a table name

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

 

Notes

SQL – Search Entire Database