/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 vote273 views1 answer
Django how to get query result count
SQL
0 vote289 views1 answer
Sql pad left 0
SQL
3 votes279 views2 answers
Truncate all tables
SQL
1 vote273 views1 answer
How to run parallel queries in sql server with entity framework
SQL
1 vote312 views2 answers
Postgresql check privileges on schema
SQL
2 votes279 views1 answer
How to delete view in sql
SQL
0 vote307 views1 answer
Sql pivot without aggregate
SQL
-1 vote280 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote286 views2 answers
How covert into int in maria db
SQL
1 vote279 views1 answer
Mysql copy table1 to table2
SQL