repo.RepoObjectColumn_MissingSource_TypeV - V
type: V ( view ), modify_date: 2022-01-05 18:06:34
RepoObject_guid: 8390291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObjectColumn_MissingSource_TypeV__1
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_MissingSource_TypeV__2
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
[column-SysObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_MissingSource_TypeV__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-RepoObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_MissingSource_TypeV__4
-
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 [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end))
is_RepoObjectColumn_name_uniqueidentifier
is_RepoObjectColumn_name_uniqueidentifier |
|
|
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
is_SysObjectColumn_name_uniqueidentifier
is_SysObjectColumn_name_uniqueidentifier |
|
|
(case when TRY_CAST([SysObjectColumn_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
persistence_source_RepoObjectColumn_guid
persistence_source_RepoObjectColumn_guid |
|
|
RepoObject_fullname
RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
SysObject_fullname
SysObject_fullname |
|
|
(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))
sql_modules_definition
repo.RepoObjectColumn_MissingSource_TypeV - V script
CREATE View [repo].[RepoObjectColumn_MissingSource_TypeV]
As
--
Select
roc.RepoObjectColumn_guid
, roc.RepoObject_guid
, roc.RepoObjectColumn_name
, roc.SysObjectColumn_name
, roc.SysObjectColumn_column_id
, roc.Repo_default_definition
, roc.Repo_default_is_system_named
, roc.Repo_default_name
, roc.Repo_definition
, roc.Repo_generated_always_type
, roc.Repo_graph_type
, roc.Repo_is_computed
, roc.Repo_is_identity
, roc.Repo_is_nullable
, roc.Repo_is_persisted
, roc.Repo_seed_value
, roc.Repo_increment_value
, roc.Repo_user_type_name
, roc.Repo_user_type_fullname
, roc.Repo_uses_database_collation
, roc.is_SysObjectColumn_missing
, roc.persistence_source_RepoObjectColumn_guid
, roc.Referencing_Count
, roc.is_query_plan_expression
, roc.has_different_sys_names
, roc.is_RepoObjectColumn_name_uniqueidentifier
, roc.is_SysObjectColumn_name_uniqueidentifier
, ro.RepoObject_fullname
, ro.SysObject_fullname
From
repo.RepoObjectColumn As roc
Inner Join
repo.RepoObject As ro
On
ro.RepoObject_guid = roc.RepoObject_guid
Where
--view
ro.SysObject_type = 'V'
And Not Exists
(
Select
1
From
[reference].RepoObjectColumn_reference_T As roc_r
Where
roc_r.referencing_RepoObject_guid = roc.RepoObject_guid
And roc_r.referencing_RepoObjectColumn_guid = roc.RepoObjectColumn_guid
And
(
roc_r.is_referenced_object = 1
Or roc_r.is_referencing_object_equal_referenced_object = 1
)
);