/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

16 votes134 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote109 views1 answer
Sql server 2016 reseed identity
SQL
0 vote125 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote132 views1 answer
Datatables server side filter where clause
SQL
0 vote130 views1 answer
Migration graphql
SQL
0 vote124 views2 answers
Zsh: command not found: mysq
SQL
1 vote132 views3 answers
How to reset id column in sql server
SQL
0 vote123 views1 answer
Best sql collation
SQL
5 votes116 views1 answer
Sqlite alter table add column
SQL
5 votes143 views1 answer
Oracle get ddl
SQL