/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 vote204 views2 answers
PostgreSQL having
SQL
2 votes244 views1 answer
Merge two columns in sql oracle
SQL
0 vote176 views1 answer
Mariadb search columns
SQL
0 vote178 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote211 views1 answer
Ubuntu access database from terminal
SQL
1 vote171 views1 answer
Mysql select month and year
SQL
0 vote230 views1 answer
Download mysql database to excel in android studio
SQL
5 votes185 views1 answer
Oracle find foreign key dependencies
SQL
1 vote174 views1 answer
Show table columns
SQL
2 votes196 views3 answers
Sql interview query questions
SQL