/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

5 votes364 views3 answers
Mysql remove unique constraint
SQL
2 votes344 views1 answer
Date_format for time sql
SQL
1 vote351 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote369 views1 answer
Oracle table privileges
SQL
50 votes408 views4 answers
Sql alter type of column
SQL
1 vote366 views1 answer
How to remove identity from a column in sql server
SQL
0 vote355 views1 answer
Difference between db.query and db.execute
SQL
18 votes350 views3 answers
Find column name in database
SQL
1 vote353 views1 answer
Oracle schema size
SQL
0 vote380 views2 answers
Temp tables in sql server
SQL