/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

10 votes136 views3 answers
Insert into auto increment mysql
SQL
3 votes167 views4 answers
Mysql create table from select statement
SQL
0 vote127 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote125 views3 answers
ChAnge TABLE name apex oracle
SQL
9 votes140 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
3 votes133 views2 answers
Having in mysql
SQL
1 vote136 views3 answers
String to int mysql
SQL
0 vote131 views1 answer
Windows aggregate functions in postgresql
SQL
19 votes132 views6 answers
Laravel sql query
SQL
0 vote91 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL