/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

2 votes171 views1 answer
Sql group by different columns
SQL
0 vote219 views1 answer
Sql server isnull function nor working count
SQL
0 vote216 views1 answer
Mysql drop trigger
SQL
0 vote221 views1 answer
Mysql isshow
SQL
0 vote232 views1 answer
Selecting all columns from table sql database
SQL
0 vote217 views1 answer
Ms sql database data size
SQL
0 vote228 views1 answer
Sql join on a subquery
SQL
1 vote240 views3 answers
Read all columns of a table sql
SQL
1 vote272 views4 answers
How to check table in postgresql from terminal
SQL
0 vote225 views1 answer
Sql server Cost Fifo query
SQL