/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 vote136 views0 answer
SQL
0 vote254 views1 answer
Get statis values sql
SQL
8 votes158 views1 answer
Oracle create datafile
SQL
1 vote152 views1 answer
Oracle start job
SQL
7 votes149 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote204 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote145 views1 answer
SQL server select to get sum of hours
SQL
0 vote152 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote146 views1 answer
Update if else mysql
SQL
5 votes156 views1 answer
Sql add column after another
SQL