/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 vote118 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote113 views1 answer
Sql comand for removing data from table
SQL
0 vote117 views1 answer
Groupby error in mysql
SQL
0 vote124 views2 answers
Plsql function that return a table
SQL
3 votes132 views1 answer
RENAME table pl sql
SQL
9 votes134 views3 answers
Where clause sql
SQL
0 vote111 views1 answer
Initcap in sql
SQL
0 vote119 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote116 views1 answer
Java sql timestamp now
SQL
1 vote136 views2 answers
Remove space in mysql
SQL