/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

1 vote304 views3 answers
Sql select only time from datetime
SQL
0 vote289 views1 answer
Search db for table name
SQL
-1 vote308 views1 answer
Capitole toulouse
SQL
5 votes303 views1 answer
Alter table add comment oracle
SQL
0 vote302 views1 answer
Truncate a table then insert data
SQL
0 vote368 views1 answer
How to add auto increment primary key
SQL
1 vote318 views1 answer
Is sql fast
SQL
5 votes314 views3 answers
Mysql update field from one table to another
SQL
11 votes308 views1 answer
Sql insert multiple rows from select
SQL
2 votes327 views1 answer
Mysql trigger after update
SQL