/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

1 vote192 views1 answer
Importance of comment in mysql
SQL
1 vote207 views1 answer
Sql count value greater than
SQL
1 vote194 views1 answer
Sql myisam vs innodb
SQL
0 vote218 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote214 views1 answer
Postgresql isnull with max
SQL
0 vote285 views1 answer
Sql select max value for each group
SQL
0 vote192 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote433 views1 answer
Sql datum formatieren
SQL
1 vote161 views1 answer
Pagination sql
SQL
0 vote215 views1 answer
How to find table lock and row lock in mysql
SQL