/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 vote73 views1 answer
Oracle sysdba connect as another user
SQL
0 vote114 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote119 views1 answer
Pgadmin see indexes
SQL
0 vote125 views1 answer
Postgres read table structure
SQL
0 vote123 views1 answer
Oracle sql copy table without data
SQL
0 vote121 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
3 votes108 views2 answers
Oracle synonym
SQL
1 vote110 views1 answer
Oracle lowercase
SQL
0 vote111 views1 answer
Arithmetic expression in sql
SQL
1 vote118 views1 answer
How to use db.execute
SQL