repo.RepoObjectColumn_gross2 - V
type: V ( view ), modify_date: 2022-09-05 16:51:19
RepoObject_guid: 43BBCCE5-AD08-EC11-8515-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObjectColumn_gross2__1
-
IndexSemanticGroup: no_group
-
[column-persistence_source_RepoObject_guid_via_Column]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__2
-
IndexSemanticGroup: no_group
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__3
-
IndexSemanticGroup: no_group
-
[column-SysObject_schema_name]; nvarchar(128)
-
[column-SysObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__4
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
[column-RepoObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__5
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__6
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
[column-SysObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__7
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-RepoObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__8
-
IndexSemanticGroup: no_group
-
[column-pk_index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_gross2__9
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
Column_name
Column_name |
|
|
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)
has_different_sys_names
has_different_sys_names |
|
|
(CONVERT([bit],case when [RepoObjectColumn_name]<>[SysObjectColumn_name] then (1) else (0) end))
Inheritance_StringAggSeparatorSql
Inheritance_StringAggSeparatorSql |
|
|
is_RepoObject_name_uniqueidentifier
is_RepoObject_name_uniqueidentifier |
|
|
(case when TRY_CAST([RepoObject_name] AS [uniqueidentifier]) IS NULL then (0) else (1) 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_SysObject_name_uniqueidentifier
is_SysObject_name_uniqueidentifier |
|
|
(case when TRY_CAST([SysObject_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)
node_id
node_id |
|
|
(CONVERT([bigint],[SysObject_id])*(10000))
persistence_source_RepoObject_guid
persistence_source_RepoObject_guid |
|
|
persistence_source_RepoObject_guid_via_Column
persistence_source_RepoObject_guid_via_Column |
|
|
persistence_source_RepoObjectColumn_guid
persistence_source_RepoObjectColumn_guid |
|
|
RepoObject_fullname
RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
RepoObject_fullname2
RepoObject_fullname2 |
|
|
(concat([RepoObject_schema_name],'.',[RepoObject_name]))
SysObject_fullname
SysObject_fullname |
|
|
(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))
SysObject_fullname2
SysObject_fullname2 |
|
|
(concat([SysObject_schema_name],'.',[SysObject_name]))
sql_modules_definition
repo.RepoObjectColumn_gross2 - V script
CREATE View [repo].[RepoObjectColumn_gross2]
As
Select
roc.RepoObjectColumn_guid
, roc.Column_name
, roc.has_different_sys_names
, roc.Inheritance_StringAggSeparatorSql
, roc.InheritanceDefinition
, roc.InheritanceType
, roc.is_persistence_Ignore
, roc.is_persistence_NoCompareButUpdate
, roc.is_persistence_NoCompareNoUpdate
, roc.is_persistence_NoInsert
, roc.is_query_plan_expression
, roc.is_RepoObjectColumn_name_uniqueidentifier
, roc.is_required_ColumnMerge
, roc.is_SysObjectColumn_missing
, roc.is_SysObjectColumn_name_uniqueidentifier
, roc.persistence_source_RepoObject_guid
, roc.persistence_source_RepoObjectColumn_guid
--should be the same like persistence_source_RepoObject_guid,
--if not, then persistence_source_RepoObjectColumn_guid is invalid and should be deleted
, persistence_source_RepoObject_guid_via_Column = roc_pers_check.RepoObject_guid
, roc.Referencing_Count
, 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_fullname
, roc.Repo_user_type_name
, roc.Repo_uses_database_collation
, roc.RepoObject_guid
, roc.RepoObjectColumn_column_id
, roc.RepoObjectColumn_fullname
, roc.RepoObjectColumn_fullname2
, roc.RepoObjectColumn_name
, roc.SysObjectColumn_column_id
, roc.SysObjectColumn_name
, roc.has_get_referenced_issue
, roc.is_repo_managed
, roc.is_ssas
, roc.is_external
, roc.is_RepoObject_name_uniqueidentifier
, roc.is_SysObject_missing
, roc.is_SysObject_name_uniqueidentifier
, roc.modify_dt
, roc.node_id
, roc.pk_index_guid
, roc.RepoObject_fullname
, roc.RepoObject_fullname2
, roc.RepoObject_name
, roc.RepoObject_Referencing_Count
, roc.RepoObject_schema_name
, roc.RepoObject_type
, roc.SysObject_fullname
, roc.SysObject_fullname2
, roc.SysObject_id
, roc.SysObject_modify_date
, roc.SysObject_name
, roc.SysObject_schema_name
, roc.SysObject_type
, roc.SysObject_parent_object_id
--based on ro.pk_index_guid
--in other words: only, if the columns are part of the PK
, roc.Property_ms_description
, roc.Description
, roc.tabcol_Description
, roc.tabcol_DisplayFolder
, roc.tabcol_Expression
, roc.tabcol_FormatString
, roc.tabcol_IsHidden
, roc.tabcol_IsKey
, roc.tabcol_IsUnique
, roc.tabcol_SummarizeBy
, roc.tabcol_Type
, ic.index_column_id
, ic.index_name
, ic.is_index_primary_key
, isAnyIndexColumn =
(
Select
Top 1
1
From
repo.IndexColumn_union_T As icu
Where
icu.RepoObjectColumn_guid = roc.RepoObjectColumn_guid
)
, roc_referenced.AntoraReferencedColumnList
, roc_referencing.AntoraReferencingColumnList
From
repo.RepoObjectColumn_gross As roc
Left Outer Join
repo.IndexColumn_union_T As ic
On
ic.index_guid = roc.pk_index_guid
And ic.RepoObjectColumn_guid = roc.RepoObjectColumn_guid
Left Join
reference.RepoObjectColumn_ReferencedList As roc_referenced
On
roc_referenced.Referencing_guid = roc.RepoObjectColumn_guid
Left Join
reference.RepoObjectColumn_ReferencingList As roc_referencing
On
roc_referencing.Referenced_guid = roc.RepoObjectColumn_guid
Left Join
repo.RepoObjectColumn As roc_pers_check
On
roc_pers_check.RepoObjectColumn_guid = roc.persistence_source_RepoObjectColumn_guid