/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 vote310 views2 answers
Mysql insert rows to another database
SQL
0 vote219 views1 answer
How to see the query of a view in mysql
SQL
0 vote257 views1 answer
Sql cmd no truncate
SQL
1 vote261 views1 answer
Myql find duplicates
SQL
0 vote238 views2 answers
Transaction php
SQL
8 votes232 views1 answer
Declare table variable sql server
SQL
0 vote226 views1 answer
Truncate a table then insert data
SQL
9 votes242 views2 answers
Sql limit to 5 results
SQL
8 votes211 views3 answers
Duplicate entry
SQL
0 vote214 views1 answer
Clone table structure mysql
SQL