repo.RepoObject_SSAS_tgt - V
type: V ( view ), modify_date: 2021-09-20 21:32:15
RepoObject_guid: 134559F6-0807-EC11-8515-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
1 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Persistence, History Table
-
persistence source: repo.RepoObject_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_RepoObject_SSAS_tgt
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 1, 1, 0
UK_RepoObject_SSAS_tgt__2
-
IndexSemanticGroup: no_group
-
[column-SysObject_schema_name]; nvarchar(128)
-
[column-SysObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 1, 0
UK_RepoObject_SSAS_tgt__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
[column-RepoObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 1, 0
idx_RepoObject_SSAS_tgt__4
-
IndexSemanticGroup: no_group
-
[column-pk_index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
-
is disabled
Column Details
_
Inheritance_StringAggSeparatorSql
Inheritance_StringAggSeparatorSql |
|
|
sql_modules_definition
repo.RepoObject_SSAS_tgt - V script
CREATE View repo.RepoObject_SSAS_tgt
As
Select
RepoObject_guid
, has_execution_plan_issue
, has_get_referenced_issue
, Inheritance_StringAggSeparatorSql
, InheritanceDefinition
, InheritanceType
, is_required_ObjectMerge
, is_repo_managed
, is_ssas
, is_SysObject_missing
, modify_dt
, pk_index_guid
, pk_IndexPatternColumnName_new
, Repo_history_table_guid
, Repo_temporal_type
, RepoObject_name
, RepoObject_Referencing_Count
, RepoObject_schema_name
, RepoObject_type
, SysObject_id
, SysObject_modify_date
, SysObject_name
, SysObject_parent_object_id
, SysObject_schema_name
, SysObject_type
, external_AntoraComponent
, external_AntoraModule
, is_external
From
repo.RepoObject
Where
is_ssas = 1