/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 vote132 views1 answer
Copy Table from SQL to CSV
SQL
1 vote125 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote133 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote125 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote178 views1 answer
Postgresql find biggest table
SQL
0 vote129 views2 answers
Update information in a mysql column
SQL
0 vote141 views1 answer
Const pool = mysql.createpool()
SQL
27 votes256 views3 answers
Mysql delete row
SQL
0 vote160 views1 answer
Split first name and last name in sql
SQL
1 vote146 views1 answer
Vagrant mysql downgrade version
SQL