repo_sys.RepoObjectReferencing - V
type: V ( view ), modify_date: 2021-08-17 20:02:40
RepoObject_guid: 0A90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObjectReferencing__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
has_different_sys_names
has_different_sys_names |
|
|
(CONVERT([bit],case when [RepoObject_schema_name]<>[SysObject_schema_name] OR [RepoObject_name]<>[SysObject_name] OR [RepoObject_type]<>[SysObject_type] then (1) else (0) end))
RepoObject_fullname
RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
SysObject_fullname
SysObject_fullname |
|
|
(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))
sql_modules_definition
repo_sys.RepoObjectReferencing - V script
/*
this view can be used to check if SysObject renaming is safe or if exists referencing objects and refactoring is required
*/
CREATE View repo_sys.RepoObjectReferencing
As
--
Select
ro.RepoObject_guid
--, [ro].[RepoObject_schema_name]
--, [ro].[RepoObject_name]
--, [ro].[RepoObject_type]
, ro.SysObject_id
--, [ro].[SysObject_schema_name]
--, [ro].[SysObject_name]
, ro.SysObject_type
, ro.SysObject_modify_date
--, [ro].[has_execution_plan_issue]
, ro.is_repo_managed
--, [ro].[modify_dt]
, ro.has_different_sys_names
, ro.RepoObject_fullname
, ro.SysObject_fullname
, referencing.referencing_schema_name
, referencing.referencing_entity_name
, referencing.referencing_id
, referencing.referencing_class
, referencing.referencing_class_desc
, referencing.is_caller_dependent
From
repo.RepoObject As ro
Cross Apply sys.dm_sql_referencing_entities ( ro.SysObject_fullname, 'OBJECT' ) As referencing