/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 vote343 views1 answer
Online sql testing tool
SQL
0 vote390 views1 answer
How do you insert boolean to postgresql
SQL
0 vote343 views1 answer
Drop all triggers oracle
SQL
0 vote462 views1 answer
How to rename a database in tsql
SQL
9 votes340 views4 answers
Last mysql
SQL
0 vote330 views1 answer
Oracle sqlp update amount / quantity
SQL
5 votes376 views1 answer
Oracle asynchronous update
SQL
0 vote359 views1 answer
Mysql query to check record exists in database table or not
SQL
11 votes356 views3 answers
Sqlite3 create table from another table
SQL
0 vote388 views1 answer
Sql select without column name
SQL