/SQL/T-SQL - Where Used List (Table/View)

T-SQL - Where Used List (Table/View)

select schema_name(o.schema_id) + '.' + o.name as [table],
       'is used by' as ref,
       schema_name(ref_o.schema_id) + '.' + ref_o.name as [object],
       ref_o.type_desc as object_type
from sys.objects o
join sys.sql_expression_dependencies dep
     on o.object_id = dep.referenced_id
join sys.objects ref_o
     on dep.referencing_id = ref_o.object_id
where o.type in ('V', 'U')
      and schema_name(o.schema_id) = 'Person'  -- put schema name here
      and o.name = 'Person'   -- put table/view name here
order by [object]

Source: dataedo.com

Similar codes

0 vote161 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
1 vote161 views1 answer
Sql headers delphi
SQL
27 votes159 views5 answers
Add column in table
SQL
0 vote156 views1 answer
MySQL FIND_IN_SET()
SQL
1 vote157 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote281 views2 answers
Execute stored procedure without db set
SQL
0 vote197 views1 answer
Tsql cte in a transaction
SQL
3 votes142 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote150 views1 answer
Add colum date in sql
SQL
0 vote163 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL