repo.RepoSchema - U

type: U ( user table ), modify_date: 2022-09-05 18:17:59

RepoObject_guid: A90747EC-8CA3-EB11-84FA-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.reposchema

Columns

Table 1. Columns of repo.RepoSchema - U
PK Column Name Data Type NULL? ID

1

Default: DF_RepoSchema_RepoSchema_guid
(newsequentialid())

uniqueidentifier

NOT NULL

Default: DF_RepoSchema_is_ssas
((0))

bit

NOT NULL

bit

NULL

Default: DF_RepoSchema_RepoSchema_guid1
(newsequentialid())

uniqueidentifier

NOT NULL

nvarchar(4000)

NULL

Default: DF_RepoSchema_RepoSchema_name
(newid())

nvarchar(128)

NOT NULL

int

NULL

Default: DF_RepoSchema_SysSchema_name
(newid())

nvarchar(128)

NOT NULL

Definition
(CONVERT([bit],case when [RepoSchema_name]<>[SysSchema_name] then (1) else (0) end))

bit

NULL

Definition (PERSISTED)
(case when TRY_CAST([RepoSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Definition (PERSISTED)
(case when TRY_CAST([SysSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Definition (PERSISTED)
('_measures')

varchar(9)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.reposchema

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.reposchema

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.reposchema

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.reposchema

Column Reference Diagram

entity_1_1_colref-repo.reposchema

Indexes

PK_RepoSchema

UK_RepoSchema

Column Details

_

RepoSchema_guid

1

RepoSchema_guid

Default: DF_RepoSchema_RepoSchema_guid
(newsequentialid())

uniqueidentifier

NOT NULL

is_ssas

is_ssas

Default: DF_RepoSchema_is_ssas
((0))

bit

NOT NULL

MeasuresRepoObjekt_guid

MeasuresRepoObjekt_guid

Default: DF_RepoSchema_RepoSchema_guid1
(newsequentialid())

uniqueidentifier

NOT NULL

RepoSchema_description

RepoSchema_description

nvarchar(4000)

NULL

has_different_sys_names

has_different_sys_names

Definition
(CONVERT([bit],case when [RepoSchema_name]<>[SysSchema_name] then (1) else (0) end))

bit

NULL

Description

(CONVERT([bit],case when [RepoSchema_name]<>[SysSchema_name] then (1) else (0) end))


is_RepoSchema_name_uniqueidentifier

is_RepoSchema_name_uniqueidentifier

Definition (PERSISTED)
(case when TRY_CAST([RepoSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Description

(case when TRY_CAST([RepoSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)


Referenced Columns

is_SysSchema_name_uniqueidentifier

is_SysSchema_name_uniqueidentifier

Definition (PERSISTED)
(case when TRY_CAST([SysSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)

int

NOT NULL

Description

(case when TRY_CAST([SysSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)


Referenced Columns

MeasuresRepoObjekt_name

MeasuresRepoObjekt_name

Definition (PERSISTED)
('_measures')

varchar(9)

NOT NULL