/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 vote188 views1 answer
How to run sql script
SQL
0 vote236 views1 answer
Sql describe
SQL
0 vote196 views1 answer
Flexible search query delete table
SQL
1 vote189 views1 answer
Get table column names sql ssms
SQL
16 votes193 views1 answer
CTE statement sql server
SQL
1 vote231 views1 answer
Difference between where and having clause
SQL
0 vote194 views1 answer
How to find columns with null values in sql
SQL
0 vote220 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote206 views1 answer
Convert polygon to text in mysql
SQL
0 vote195 views1 answer
Mysql docker image arjun
SQL