workflow.ProcedureDependency_PersistenceDependency_src - V
type: V ( view ), modify_date: 2021-11-17 23:12:45
RepoObject_guid: FF1F04C7-F347-EC11-8530-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
Indexes
PK_ProcedureDependency_PersistenceDependency_src
-
IndexSemanticGroup: referenced_Procedure_RepoObject_guid,referencing_Procedure_RepoObject_guid
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
idx_ProcedureDependency_PersistenceDependency_src__2
-
IndexSemanticGroup: no_group
-
[column-referenced_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_ProcedureDependency_PersistenceDependency_src__3
-
IndexSemanticGroup: no_group
-
[column-referencing_Procedure_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_Procedure_RepoObject_guid
1 |
referenced_Procedure_RepoObject_guid |
|
|
referencing_Procedure_RepoObject_guid
2 |
referencing_Procedure_RepoObject_guid |
|
|
sql_modules_definition
workflow.ProcedureDependency_PersistenceDependency_src - V script
create View [workflow].[ProcedureDependency_PersistenceDependency_src]
As
Select
referenced_Procedure_RepoObject_guid = T1.referenced_usp_persistence_RepoObject_guid
, referencing_Procedure_RepoObject_guid = T1.referencing_usp_persistence_RepoObject_guid
, is_PersistenceDependency = 1
--, T1.referenced_RepoObject_guid
--, T1.referencing_RepoObject_guid
From
reference.Persistence As T1
Where
( Not ( T1.referenced_usp_persistence_RepoObject_guid Is Null ))
And ( Not ( T1.referencing_usp_persistence_RepoObject_guid Is Null ))