/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 vote202 views1 answer
Sql last 7 days
SQL
12 votes209 views2 answers
Delete all nodes neo4j
SQL
21 votes203 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote204 views1 answer
Tsql create unique index composite
SQL
24 votes215 views6 answers
Rename a column in sql server
SQL
5 votes226 views1 answer
Oracle drop index if exists
SQL
1 vote222 views1 answer
SQL Integer devision
SQL
0 vote205 views1 answer
Sql select by content lenght
SQL
3 votes286 views1 answer
Apex call duration
SQL
0 vote209 views1 answer
Get the previous column of a table in mysql
SQL