Breaking News: Grepper is joining You.com. Read the official announcement!

find usage of table in sql server

Lazar answered on November 29, 2021 Popularity 3/10 Helpfulness 4/10

answer find usage of table in sql server

find usage of table in sql server

Comment

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]

Popularity 3/10 Helpfulness 4/10 Language sql

Source: dataedo.com

Tags: find sql sql-server

Link to this answer
Share Copy Link

Contributed on Nov 29 2021

Lazar

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

find usage of table in sql server

Contents

More Related Answers

find usage of table in sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.