repo.IndexColumn_union - V

CREATE View repo.IndexColumn_union
As
Select
    T1.index_guid
  , T1.index_column_id
  , T1.is_descending_key
  , T1.RepoObjectColumn_guid
  , T1.parent_RepoObject_guid
  , T1.index_name
  , T1.parent_schema_name
  , T1.parent_SysObject_name
  , T1.SysObject_column_name
  , T1.SysObject_column_user_type_fullname
  , T1.is_index_unique
  , T1.is_index_primary_key
  , T1.is_index_real
  , T1.parent_SysObject_fullname
  , ColumnsPerIndex = Count ( * ) Over ( Partition By T1.index_guid )
From
    repo_sys.IndexColumn_unique As T1
Where
    Not T1.index_guid Is Null
Union All
Select
    T2.index_guid
  , T2.index_column_id
  , T2.is_descending_key
  , T2.RepoObjectColumn_guid
  , T2.parent_RepoObject_guid
  , T2.index_name
  , T2.parent_schema_name
  , T2.parent_Object_name
  , T2.Object_column_name
  , T2.column_user_type_fullname
  , T2.is_index_unique
  , T2.is_index_primary_key
  , T2.is_index_real
  , T2.parent_Object_fullname
  , ColumnsPerIndex = Count ( * ) Over ( Partition By T2.index_guid )
From
    repo.IndexColumn_virtual_gross As T2
Where
    Not T2.index_guid Is Null
Union All
Select
    T2.index_guid
  , T2.index_column_id
  , T2.is_descending_key
  , T2.RepoObjectColumn_guid
  , T2.parent_RepoObject_guid
  , T2.index_name
  , T2.parent_schema_name
  , T2.parent_Object_name
  , T2.Object_column_name
  , T2.column_user_type_fullname
  , T2.is_index_unique
  , T2.is_index_primary_key
  , T2.is_index_real
  , T2.parent_Object_fullname
  , ColumnsPerIndex = Count ( * ) Over ( Partition By T2.index_guid )
From
    repo.IndexColumn_ssas_gross As T2
Where
    Not T2.index_guid Is Null