repo.RepoSchema_ssas_tgt - V
type: V ( view ), modify_date: 2021-11-16 11:50:23
RepoObject_guid: 53CA43F5-1F07-EC11-8515-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Persistence, History Table
-
persistence source: repo.RepoSchema_ssas_src - V
-
is_persistence: 1
-
is_persistence_check_duplicate_per_pk: 0
-
is_persistence_check_for_empty_source: 0
-
is_persistence_delete_changed: 0
-
is_persistence_delete_missing: 1
-
is_persistence_insert: 1
-
is_persistence_truncate: 0
-
is_persistence_update_changed: 1
-
has_history: 0
-
has_history_columns: 0
Indexes
PK_RepoSchema_ssas_tgt
-
IndexSemanticGroup: no_group
-
[column-RepoSchema_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
UK_RepoSchema_ssas_tgt__2
-
IndexSemanticGroup: no_group
-
[column-RepoSchema_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 1, 0
Column Details
_
has_different_sys_names
has_different_sys_names |
|
|
(CONVERT([bit],case when [RepoSchema_name]<>[SysSchema_name] then (1) else (0) end))
is_RepoSchema_name_uniqueidentifier
is_RepoSchema_name_uniqueidentifier |
|
|
(case when TRY_CAST([RepoSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
is_SysSchema_name_uniqueidentifier
is_SysSchema_name_uniqueidentifier |
|
|
(case when TRY_CAST([SysSchema_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
sql_modules_definition
repo.RepoSchema_ssas_tgt - V script
CREATE View repo.[RepoSchema_ssas_tgt]
As
Select
RepoSchema_guid
, has_different_sys_names
, is_ssas
, is_SysSchema_missing
, [RepoSchema_description]
, RepoSchema_name
, SysSchema_id
, SysSchema_name
, is_RepoSchema_name_uniqueidentifier
, is_SysSchema_name_uniqueidentifier
From
repo.RepoSchema
Where
is_ssas = 1