/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 vote113 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote63 views1 answer
Kannst du deine finger trainieren
SQL
1 vote137 views1 answer
Sql server loop over query
SQL
0 vote166 views1 answer
Bigrock database connection string
SQL
0 vote160 views1 answer
Selecting from a view SQL
SQL
0 vote109 views1 answer
Multiple left join mysql
SQL
17 votes125 views5 answers
Order by sql
SQL
9 votes116 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
1 vote121 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
2 votes102 views1 answer
Oracle cpu per session
SQL