/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

0 vote188 views1 answer
Acual month sql
SQL
20 votes206 views5 answers
Reset auto increment mysql
SQL
1 vote196 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote188 views1 answer
C# check if mysql query modified rows
SQL
27 votes209 views6 answers
Set password mysql
SQL
0 vote202 views1 answer
Sqlite insert or update
SQL
1 vote186 views1 answer
Oracle sql create view
SQL
2 votes201 views1 answer
How to get weekday from old date in sql
SQL
1 vote193 views2 answers
Mysql select tables with name like
SQL
0 vote288 views1 answer
Run mysql xampp shell
SQL