/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 vote199 views1 answer
Mysql backup query
SQL
0 vote192 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote258 views1 answer
How to get table current identity value in sql server
SQL
0 vote156 views1 answer
Check connections to database postgres
SQL
0 vote181 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote172 views1 answer
Mysql set variable to today's date
SQL
0 vote168 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote206 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote174 views1 answer
Sqlite3 read only
SQL
1 vote201 views1 answer
Mysql search like order by best match
SQL