/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 vote268 views2 answers
Delete the last item in a table sql
SQL
38 votes321 views4 answers
Count sql
SQL
49 votes392 views6 answers
Mysql add column to table
SQL
1 vote391 views1 answer
Postgresql can you have null foreign key
SQL
0 vote332 views1 answer
How to run mysql in git bash
SQL
5 votes296 views1 answer
Oracle list packages
SQL
1 vote301 views1 answer
Set statiscis on in sql server
SQL
1 vote311 views1 answer
Timestamp in sqlite
SQL
0 vote289 views1 answer
Mysql percentage of total
SQL
0 vote320 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL