/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

24 votes154 views4 answers
Postgres delete database
SQL
0 vote172 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote144 views1 answer
Update mysql centos
SQL
1 vote148 views1 answer
Drush sql-dump
SQL
5 votes179 views1 answer
Oracle ora-00054 resource busy
SQL
2 votes164 views1 answer
Mariadb select multiple rows into one column
SQL
5 votes148 views1 answer
Oracle ORA-00054 origin
SQL
0 vote147 views1 answer
Mysql search like but first exact match
SQL
0 vote147 views1 answer
Difference between varchar and varchar2
SQL
0 vote138 views1 answer
Running query in redshift
SQL