/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

15 votes260 views6 answers
Drop foreign key mysql
SQL
1 vote266 views1 answer
Postgres killing connections on db
SQL
0 vote265 views2 answers
Import .sql into postgres db command
SQL
0 vote328 views2 answers
Mysql insert rows to another database
SQL
0 vote250 views1 answer
Duplicate value unique constraint mysql error
SQL
1 vote243 views1 answer
Sql drop with dependencies
SQL
0 vote274 views2 answers
Connect to mysql server mac terminal
SQL
2 votes230 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote277 views1 answer
Postgresql port 5432 not open
SQL
4 votes245 views1 answer
Select nls_date_format
SQL