repo.IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check - V
type: V ( view ), modify_date: 2022-01-05 18:06:33
RepoObject_guid: 657159E3-27E6-EB11-8507-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check__1
-
IndexSemanticGroup: no_group
-
[column-referencing_RepoObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check__2
-
IndexSemanticGroup: no_group
-
[column-referenced_RepoObjectColumn_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check__3
-
IndexSemanticGroup: no_group
-
[column-index_guid]; uniqueidentifier
-
[column-RowNumberInReferencing]; bigint
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check__4
-
IndexSemanticGroup: no_group
-
[column-index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_RepoObject_fullname
referenced_RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
referenced_RepoObjectColumn_name
referenced_RepoObjectColumn_name |
|
|
referencing_RepoObject_fullname
referencing_RepoObject_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
referencing_RepoObjectColumn_name
referencing_RepoObjectColumn_name |
|
|
sql_modules_definition
repo.IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check - V script
CREATE View repo.IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_check
As
Select
T1.index_guid
, T1.is_descending_key
, T1.referenced_RepoObject_guid
, T1.index_column_id
, T1.referenced_RepoObjectColumn_guid
, T1.RowNumberInReferencing
, T1.referencing_RepoObject_guid
, T1.referencing_RepoObjectColumn_guid
, iset.IndexPatternColumnDatatype
, iset.IndexPatternColumnName
, iset.IndexSemanticGroup
, referenced_RepoObject_fullname = ro1.RepoObject_fullname
, referenced_RepoObjectColumn_name = roc1.RepoObjectColumn_name
, referencing_RepoObject_fullname = ro2.RepoObject_fullname
, referencing_RepoObjectColumn_name = roc2.RepoObjectColumn_name
From
repo.IndexColumn_ReferencedReferencing_HasFullColumnsInReferencing_T As T1
Left Outer Join
repo.RepoObjectColumn As roc2
On
T1.referencing_RepoObjectColumn_guid = roc2.RepoObjectColumn_guid
Left Outer Join
repo.RepoObjectColumn As roc1
On
T1.referenced_RepoObjectColumn_guid = roc1.RepoObjectColumn_guid
Left Outer Join
repo.RepoObject As ro2
On
T1.referencing_RepoObject_guid = ro2.RepoObject_guid
Left Outer Join
repo.RepoObject As ro1
On
T1.referenced_RepoObject_guid = ro1.RepoObject_guid
Left Outer Join
repo.Index_Settings As iset
On
T1.index_guid = iset.index_guid