/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 vote185 views1 answer
Sqlite löschen einer tabelle
SQL
7 votes176 views1 answer
Set sequence value oracle
SQL
19 votes283 views5 answers
Mysql between date range
SQL
0 vote154 views1 answer
Lister les index d'une table oracle
SQL
0 vote191 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote192 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote214 views1 answer
Sql query for login with email or username
SQL
0 vote166 views1 answer
Psql list rules
SQL
4 votes132 views2 answers
Create table if not exists postgres
SQL
0 vote186 views1 answer
Sql find record cannot cast date
SQL