/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

2 votes279 views3 answers
Mysql list tables by size
SQL
2 votes276 views1 answer
Apex date today add days
SQL
3 votes342 views2 answers
Oracle drop sequence
SQL
0 vote283 views1 answer
Postgresql remove new line from string
SQL
1 vote322 views3 answers
How to reset id column in sql server
SQL
7 votes279 views1 answer
Safe mode mysql
SQL
2 votes294 views1 answer
Mysql last 7 days including today
SQL
1 vote274 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote276 views1 answer
Hive batch drop table
SQL
0 vote318 views1 answer
How to find all children of a record with only parent ID in sql
SQL