repo.RepoObjectColumn_SSAS_src - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: 124559F6-0807-EC11-8515-A81E8446D5B0

Examples

Entity Diagram

entity-repo.repoobjectcolumn_ssas_src

Columns

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

1

uniqueidentifier

NOT NULL

int

NOT NULL

bit

NOT NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobjectcolumn_ssas_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobjectcolumn_ssas_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobjectcolumn_ssas_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobjectcolumn_ssas_src

Column Reference Diagram

entity_1_1_colref-repo.repoobjectcolumn_ssas_src

Indexes

PK_RepoObjectColumn_SSAS_src

idx_RepoObjectColumn_SSAS_src__2

idx_RepoObjectColumn_SSAS_src__3

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

is_SysObjectColumn_missing

is_SysObjectColumn_missing

int

NOT NULL

Repo_is_nullable

Repo_is_nullable

bit

NOT NULL

Repo_user_type_fullname

Repo_user_type_fullname

nvarchar(500)

NULL

Repo_user_type_name

Repo_user_type_name

nvarchar(500)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_name

RepoObjectColumn_name

nvarchar(128)

NOT NULL

SysObjectColumn_name

SysObjectColumn_name

nvarchar(128)

NOT NULL

sql_modules_definition

repo.RepoObjectColumn_SSAS_src - V script
/*
<<property_start>>Description
converts xref:sqldb:ssas.tmschema_columns_t.adoc[] into xref:sqldb:repo.repoobjectcolumn.adoc[]
<<property_end>>
*/
CREATE View [repo].[RepoObjectColumn_SSAS_src]
As
Select
    --PK: RepoObjectColumn_guid
    T2.RepoObjectColumn_guid
  , is_SysObjectColumn_missing = 0
  , Repo_is_nullable           = IsNull ( T2.tables_columns_isNullable, 1 )
  , Repo_user_type_name        = T2.tables_columns_dataType
  , Repo_user_type_fullname    = T2.tables_columns_dataType
  , RepoObjectColumn_name      = T2.tables_columns_name
  , T2.RepoObject_guid
  , SysObjectColumn_name       = T2.tables_columns_name
----could be required:
--, is_repo_managed            = 1
----could be required, but is missing in target
--, is_ssas                    = 1
From
    ssas.model_json_311_tables_columns_T As T2