/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 vote363 views1 answer
C# execute transact sql
SQL
0 vote341 views1 answer
Sql server list table sizes
SQL
13 votes357 views2 answers
Get date from now() mysql
SQL
2 votes338 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote382 views1 answer
Drop view in mysql
SQL
4 votes350 views1 answer
Postgresql list sequences
SQL
0 vote337 views1 answer
TSQL convert csv to table
SQL
2 votes392 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
1 vote347 views1 answer
Myql find duplicates
SQL
5 votes359 views1 answer
Sql table columns
SQL