/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 vote330 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote327 views3 answers
Mysql Server Start
SQL
11 votes341 views6 answers
Distinct sql
SQL
0 vote318 views1 answer
Get cpu details sql
SQL
0 vote354 views1 answer
Add week ending date sql server
SQL
1 vote316 views1 answer
Mysql show table character set
SQL
2 votes294 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote351 views1 answer
Oracle concat datetime
SQL
103 votes540 views1 answer
Like sql
SQL
12 votes328 views1 answer
Docker mysql random root password
SQL