/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 vote196 views1 answer
Alter domain sql
SQL
-1 vote166 views1 answer
Module operator in oracle sql
SQL
11 votes179 views1 answer
Ddl materialized view
SQL
0 vote176 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
36 votes181 views6 answers
Delete from where sql
SQL
1 vote150 views1 answer
Sqlite check if row exists
SQL
0 vote185 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
3 votes200 views5 answers
Sql select
SQL
0 vote185 views1 answer
Providername system.data. mysql
SQL
3 votes172 views1 answer
Apex set debug level
SQL