/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 vote215 views1 answer
Postgres cast as currency format
SQL
0 vote216 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote206 views1 answer
Datatables server side filter where clause
SQL
8 votes224 views1 answer
Oracle current date plus 1 month
SQL
0 vote187 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote217 views2 answers
End mysql command
SQL
3 votes205 views2 answers
Sql get month name
SQL
0 vote183 views1 answer
Learn sqlite dart
SQL
1 vote198 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote200 views1 answer
Sql week commencing date
SQL