reference.additional_Reference_from_properties_src - V
type: V ( view ), modify_date: 2021-10-02 13:23:34
RepoObject_guid: 48EFD408-A51F-EC11-8523-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
4 |
|
|
||
5 |
|
|
||
6 |
|
|
||
7 |
|
|
||
8 |
|
|
||
9 |
|
|
||
10 |
|
|
Indexes
PK_additional_Reference_from_properties_src
-
IndexSemanticGroup: no_group
-
[column-referenced_AntoraComponent]; nvarchar(max)
-
[column-referenced_AntoraModule]; nvarchar(max)
-
[column-referenced_Schema]; nvarchar(max)
-
[column-referenced_Object]; nvarchar(max)
-
[column-referenced_Column]; nvarchar(max)
-
[column-referencing_AntoraComponent]; nvarchar(max)
-
[column-referencing_AntoraModule]; nvarchar(max)
-
[column-referencing_Schema]; nvarchar(max)
-
[column-referencing_Object]; nvarchar(max)
-
[column-referencing_Column]; nvarchar(max)
-
-
PK, Unique, Real: 1, 1, 0
Column Details
_
sql_modules_definition
reference.additional_Reference_from_properties_src - V script
CREATE View reference.additional_Reference_from_properties_src
As
Select
Distinct
referenced_AntoraComponent = pvt.[1]
, referenced_AntoraModule = pvt.[2]
, referenced_Schema = pvt.[3]
, referenced_Object = pvt.[4]
, referenced_Column = pvt.[5]
, referencing_AntoraComponent = pvt.[6]
, referencing_AntoraModule = pvt.[7]
, referencing_Schema = pvt.[8]
, referencing_Object = pvt.[9]
, referencing_Column = pvt.[10]
From
(
Select
RepoObject_guid
, property_name
, LinePerGuidProperty
--, property_value
--, value_line
--, value_line_len
, value_line_row
, RowPerGuidPropertyLine
From
property.RepoObjectProperty_SelectedPropertyName_split
) As tbl
Pivot
(
Max(value_line_row)
For RowPerGuidPropertyLine In
( [1], [2], [3], [4], [5], [6], [7], [8], [9], [10] )
) As pvt
Where
property_name = 'additional_reference_csv'
And pvt.[5] <> 'null'
And pvt.[5] <> ''
And pvt.[10] <> 'null'
And pvt.[10] <> ''