/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 vote364 views3 answers
Getdate function in postgresql
SQL
0 vote389 views1 answer
Mysql reset wp_options
SQL
-1 vote388 views1 answer
Pl sql drop trigger
SQL
0 vote375 views1 answer
Case insensitive sql
SQL
0 vote348 views1 answer
Mssql current date
SQL
2 votes376 views2 answers
Sql query to copy data from one column to another
SQL
3 votes350 views1 answer
Convert sqlite table to pandas dataframe
SQL
2 votes379 views1 answer
Mysql select default if null
SQL
0 vote332 views1 answer
Oracle list dblink
SQL
0 vote352 views1 answer
Show create table in postgresql
SQL