/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

0 vote268 views1 answer
Top 3 salary in sql
SQL
-1 vote344 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
9 votes246 views3 answers
Mysql get last id
SQL
2 votes248 views2 answers
Mysql all columns
SQL
0 vote277 views1 answer
How we can perform acid Operations in sql with examples
SQL
1 vote258 views2 answers
Select only columns that are not empty oracle sql
SQL
11 votes255 views2 answers
Safe mode off mysql
SQL
1 vote268 views1 answer
Oracle datafile max size 32gb
SQL
2 votes269 views1 answer
Add new column not null sql server
SQL
0 vote261 views1 answer
Drop column from table if exist on live server mysql
SQL