/SQL/Sql server: query to find out all the places where the table is used

Sql server: query to find out all the places where the table is used

SELECT DISTINCT
    o.name AS Object_Name,o.type_desc
    FROM sys.sql_modules        m 
        INNER JOIN sys.objects  o ON m.object_id=o.object_id
    WHERE m.definition Like '%WhateverIAmSearchingFor%'

Source: stackoverflow.com

Similar codes

16 votes190 views1 answer
CTE statement sql server
SQL
0 vote203 views1 answer
Mysql trigger to delete old data
SQL
0 vote208 views1 answer
WHERE not regex in SQL
SQL
0 vote226 views1 answer
Bigrock database connection string
SQL
3 votes196 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote184 views1 answer
Sql select min
SQL
0 vote256 views1 answer
Oracle simple quote
SQL
0 vote195 views1 answer
Incorrect string value: mysql
SQL
2 votes202 views4 answers
Sql query interview questions
SQL
1 vote205 views1 answer
How to group by month using sql server
SQL