repo.RepoObjectColumn_external_tgt - V
type: V ( view ), modify_date: 2022-09-05 17:05:53
RepoObject_guid: C3D025E7-1A1B-EC11-8520-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Persistence, History Table
-
persistence source: repo.RepoObjectColumn_external_src - V
-
is_persistence: 1
-
is_persistence_check_duplicate_per_pk: 0
-
is_persistence_check_for_empty_source: 0
-
is_persistence_delete_changed: 0
-
is_persistence_delete_missing: 1
-
is_persistence_insert: 1
-
is_persistence_truncate: 0
-
is_persistence_update_changed: 1
-
has_history: 0
-
has_history_columns: 0
Indexes
PK_RepoObjectColumn_external_tgt
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
UK_RepoObjectColumn_external_tgt__2
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
[column-SysObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 1, 0
UK_RepoObjectColumn_external_tgt__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-RepoObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 1, 0
idx_RepoObjectColumn_external_tgt__4
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
-
is disabled
idx_RepoObjectColumn_external_tgt__5
-
IndexSemanticGroup: no_group
-
[column-SysObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_external_tgt__6
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
Inheritance_StringAggSeparatorSql
Inheritance_StringAggSeparatorSql |
|
|
persistence_source_RepoObjectColumn_guid
persistence_source_RepoObjectColumn_guid |
|
|
sql_modules_definition
repo.RepoObjectColumn_external_tgt - V script
CREATE View [repo].[RepoObjectColumn_external_tgt]
As
Select
T1.RepoObjectColumn_guid
, T1.Inheritance_StringAggSeparatorSql
, T1.InheritanceDefinition
, T1.InheritanceType
, T1.is_persistence_Ignore
, T1.is_persistence_NoCompareButUpdate
, T1.is_persistence_NoCompareNoUpdate
, T1.is_persistence_NoInsert
, T1.is_query_plan_expression
, T1.is_required_ColumnMerge
, T1.is_SysObjectColumn_missing
, T1.persistence_source_RepoObjectColumn_guid
, T1.Referencing_Count
, T1.Repo_default_definition
, T1.Repo_default_is_system_named
, T1.Repo_default_name
, T1.Repo_definition
, T1.Repo_generated_always_type
, T1.Repo_graph_type
, T1.Repo_is_computed
, T1.Repo_is_identity
, T1.Repo_is_nullable
, T1.Repo_is_persisted
, T1.Repo_seed_value
, T1.Repo_increment_value
, T1.Repo_user_type_name
, T1.Repo_user_type_fullname
, T1.Repo_uses_database_collation
, T1.RepoObjectColumn_column_id
, T1.RepoObjectColumn_name
, T1.RepoObject_guid
, T1.SysObjectColumn_column_id
, T1.SysObjectColumn_name
From
repo.RepoObjectColumn As T1
Where
Exists
(
Select
1
From
repo.RepoObject_external_tgt As T2
Where
T2.RepoObject_guid = T1.RepoObject_guid
)