/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 vote107 views1 answer
How to use sqlcommand
SQL
7 votes115 views5 answers
Max 3 salary in sql
SQL
0 vote146 views1 answer
Sql alchemy escape ; in insert statement
SQL
1 vote102 views1 answer
How to install mysql 8.0 windows service
SQL
92 votes295 views6 answers
Substring
SQL
5 votes111 views3 answers
Oracle first day of last year
SQL
7 votes113 views2 answers
Oracle sql drop index
SQL
0 vote128 views1 answer
Sql basic commands
SQL
1 vote94 views1 answer
Oracle check table space
SQL
0 vote108 views1 answer
How to update sql server version
SQL