/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

6 votes176 views5 answers
Alter table oracle
SQL
0 vote169 views1 answer
Truncate a table then insert data
SQL
0 vote170 views1 answer
Group_concat only returns one row
SQL
31 votes173 views3 answers
Sql count(*)
SQL
1 vote190 views1 answer
Mysql select and count left join
SQL
1 vote179 views3 answers
Sql server get week dates from week number
SQL
0 vote179 views1 answer
Sqlplus change user
SQL
0 vote222 views1 answer
For select oracle
SQL
2 votes182 views2 answers
Created at and updated at in mysql
SQL
1 vote177 views1 answer
Sql get missing id
SQL