/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

3 votes129 views1 answer
Sql replace character in string in all records
SQL
0 vote182 views1 answer
Do you know sql
SQL
0 vote126 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote205 views1 answer
How to update random rows in sql
SQL
0 vote154 views1 answer
Postgressql uuid
SQL
0 vote132 views1 answer
Groupby sort sql hive
SQL
12 votes140 views1 answer
Docker run mysql image
SQL
1 vote134 views3 answers
Mysql parse int
SQL
1 vote134 views1 answer
Mariadb get column names from table
SQL
0 vote125 views1 answer
Check mysql password with docker container magento 2
SQL