property.RepoObjectProperty_external_tgt - V
type: V ( view ), modify_date: 2021-09-22 21:12:49
RepoObject_guid: 47948D1F-D01B-EC11-8521-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
Persistence, History Table
-
persistence source: property.RepoObjectProperty_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_RepoObjectProperty_external_tgt
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-property_name]; nvarchar(128)
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObjectProperty_external_tgt__2
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
-
is disabled
Column Details
sql_modules_definition
property.RepoObjectProperty_external_tgt - V script
CREATE View property.RepoObjectProperty_external_tgt
As
Select
--pk: RepoObject_guid, property_name
rop.RepoObject_guid
, rop.property_name
, rop.property_value
, rop.RepoObjectProperty_id
, rop.inheritance
From
property.RepoObjectProperty As rop
Where
Exists
(
Select
1
From
repo.RepoObject As ro
Where
ro.RepoObject_guid = rop.RepoObject_guid
And ro.is_external = 1
)
And Exists
(
Select
1
From
property.PropertyName_RepoObject_T As pn
Where
pn.property_name = rop.property_name
--only property_name which are used in inheritance
And pn.has_inheritance = 1
)