/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

5 votes243 views2 answers
Sql number columns
SQL
1 vote228 views1 answer
Mysql query where in select
SQL
1 vote222 views1 answer
Mariadb alter user host
SQL
0 vote280 views2 answers
Fanyi
SQL
0 vote245 views4 answers
Open mysql port bitnami tomact
SQL
3 votes212 views1 answer
Oracle detect invalid password
SQL
7 votes250 views1 answer
Query postgres delete duplicates
SQL
0 vote221 views1 answer
Sql last 7 days
SQL
0 vote225 views2 answers
Default constraint in ms sql
SQL
0 vote234 views1 answer
How to add unique key constraint in mysql
SQL