repo.RepoSchema_ssas_src - V

type: V ( view ), modify_date: 2021-11-16 12:01:41

RepoObject_guid: 52CA43F5-1F07-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.reposchema_ssas_src

Columns

Table 1. Columns of repo.RepoSchema_ssas_src - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NOT NULL

int

NOT NULL

int

NOT NULL

nvarchar(max)

NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.reposchema_ssas_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.reposchema_ssas_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.reposchema_ssas_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.reposchema_ssas_src

Column Reference Diagram

entity_1_1_colref-repo.reposchema_ssas_src

Indexes

PK_RepoSchema_ssas_src

Column Details

_

RepoSchema_name

1

RepoSchema_name

nvarchar(128)

NOT NULL

Referenced Columns

is_ssas

is_ssas

int

NOT NULL

Referencing Columns

is_SysSchema_missing

is_SysSchema_missing

int

NOT NULL

RepoSchema_description

RepoSchema_description

nvarchar(max)

NULL

SysSchema_name

SysSchema_name

nvarchar(128)

NOT NULL

sql_modules_definition

repo.RepoSchema_ssas_src - V script
/*
ssas databasename is used as RepoSchema_name
*/
CREATE View repo.RepoSchema_ssas_src
As
Select
    --PK: RepoSchema_name
    RepoSchema_name        = T1.databasename
  , is_ssas                = 1
  , is_SysSchema_missing   = 0
  , RepoSchema_description = Coalesce ( T1.l2_description, T2.descriptions_StrAgg )
  , SysSchema_name         = T1.databasename
From
    ssas.model_json_20                           As T1
    Left Join
        ssas.model_json_2011_descriptions_StrAgg As T2
            On
            T2.databasename = T1.databasename