/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 votes325 views1 answer
Mysql select random id from table
SQL
0 vote329 views1 answer
Many rows to 1 string mysql
SQL
0 vote343 views1 answer
Permission denied postgres \copy csv command line
SQL
7 votes345 views1 answer
Oracle reset sequence
SQL
5 votes335 views1 answer
Find table from column name in sql
SQL
0 vote324 views1 answer
Month mysql
SQL
0 vote333 views1 answer
Cast as decimal postgresql
SQL
0 vote398 views1 answer
Get initial in sql
SQL
0 vote362 views1 answer
Split string by comma in sql server
SQL
13 votes351 views1 answer
Sql join 3 tables on id
SQL