Check if SQL object is referenced by any other SQL objects

debugcn 에 게시 Dev

VixterJ

I was just reading this SO thread and had a question for @Mack regarding whether there is a way to check if a SQL object is referenced by any other SQL objects.

He (@Mack) used T-SQL and DMVs to accomplish something similar in his answer.

Is this possible, if so how?

I would have posted this as a comment, but I don't have sufficient reputation yet...

Mack

You can, but not with a DMV instead you'll need a related dynamic management function(DMF) dm_sql_referencing_entities (more info here).

Here is the code:

SELECT referencing_schema_name
     , referencing_entity_name
FROM sys.dm_sql_referencing_entities ('*schemaname.objectname*', 'OBJECT');

Here's a link to the MSDN page on DMVs and DMFs.

이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.

침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제

에서 수정2021-06-1

몇 마디 만하겠습니다

0리뷰

로그인참여 후 검토

Related 관련 기사

기사

Check if SQL object is referenced by any other SQL objects

Check if SQL object is referenced by any other SQL objects

SQL Server check if where clause is true for any row

SQL Query to check Range

NSPredicate SUBQUERY for object composed of arrays of other objects

how is Array object different from other objects

check if any other copy is in process before my xcopy command

Join 2 other tables with SQL?

SQL Union "All Other" Row

Regex in SQL Server to check whitespaces

C# SQL database check

Creating a composite object from two other core data objects

sys.sql_modules 및 sys.objects의 잘못된 object_name 및 정의 관계

Way to do "Any" on an aggregation in SQL Server

IN query not returning any result, worklight SQL Adapter

Saving model object into SQL DB

sql dependency Invalid object name '

SQL: group by from other table and invert result

SQL Update a column dependent on other two columns

SQL Database vs Java Serialized Objects To File?

MS SQL coonditional check null 값

SQL select where but only check if parameter is true

sql: How to check a zipcode is exist in zipcode range

SQL unique : manual check vs catch exception

how to check for a null value in t-sql

Check row existence in SQL Server with PowerShell

Мой SQL вернул пустой набор результатов, какое решение?

Процедура SQL выполняет первую строку, а затем останавливается

SQL Query- Table as invalid object

Using AutoMapper to create an object, which represents a result of comparing two other objects

Loop over a reference object multiple times to copy its properties to other objects in Javascript/Angularjs