repo.SysObject_RepoObject_via_guid - V
type: V ( view ), modify_date: 2021-09-21 18:26:12
RepoObject_guid: 5B90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_SysObject_RepoObject_via_guid__1
-
IndexSemanticGroup: no_group
-
[column-history_table_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_SysObject_RepoObject_via_guid__2
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_SysObject_RepoObject_via_guid__3
-
IndexSemanticGroup: no_group
-
[column-RepoObject_SysObject_schema_name]; nvarchar(128)
-
[column-RepoObject_SysObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_SysObject_RepoObject_via_guid__4
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
[column-RepoObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
is_RepoObject_name_uniqueidentifier
is_RepoObject_name_uniqueidentifier |
|
|
(case when TRY_CAST([RepoObject_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
is_SysObject_name_uniqueidentifier
is_SysObject_name_uniqueidentifier |
|
|
(case when TRY_CAST([SysObject_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)
RepoObject_SysObject_parent_object_id
RepoObject_SysObject_parent_object_id |
|
|
RepoObject_SysObject_schema_name
RepoObject_SysObject_schema_name |
|
|
sql_modules_definition
repo.SysObject_RepoObject_via_guid - V script
CREATE View repo.SysObject_RepoObject_via_guid
As
--
Select
so.SysObject_id
, ro.is_repo_managed
, so.SysObject_schema_name
, so.SysObject_name
, SysObject_type = so.type
, SysObject_type_desc = so.type_desc
, modify_date = so.modify_date
, parent_object_id = so.parent_object_id
, SysObject_RepoObject_guid = so.SysObject_RepoObject_guid
, history_table_guid = ro_hist.RepoObject_guid
, so.history_table_id
, so.temporal_type
--, [so].[max_column_id_used] AS [SysObject_max_column_id_used]
, ro.Repo_history_table_guid
, ro.Repo_temporal_type
, RepoObject_guid = ro.RepoObject_guid
, ro.RepoObject_schema_name
, ro.RepoObject_name
, ro.RepoObject_type
, RepoObject_SysObject_id = ro.SysObject_id
, RepoObject_SysObject_schema_name = ro.SysObject_schema_name
, RepoObject_SysObject_name = ro.SysObject_name
, RepoObject_SysObject_type = ro.SysObject_type
, RepoObject_SysObject_modify_date = ro.SysObject_modify_date
, RepoObject_SysObject_parent_object_id = ro.SysObject_parent_object_id
, RepoObject_is_SysObject_missing = ro.is_SysObject_missing
, ro.is_RepoObject_name_uniqueidentifier
, ro.is_SysObject_name_uniqueidentifier
, ro.is_ssas
, ro.is_external
--, [ro].SysObject_parent_object_id AS [RepoObject_parent_SysObject_id]
--, [ro].[SysObject_temporal_type] AS [RepoObject_SysObject_temporal_type]
--, [ro].[SysObject_history_table_id] AS [RepoObject_SysObject_history_table_id]
--, [ro].[SysObject_max_column_id_used] AS [RepoObject_SysObject_max_column_id_used]
From
repo_sys.SysObject As so
Left Outer Join
repo.RepoObject As ro
On
ro.RepoObject_guid = so.SysObject_RepoObject_guid
And ro.is_ssas = 0
And ro.is_external = 0
Left Outer Join
repo.RepoObject As ro_hist
On
ro_hist.SysObject_id = so.history_table_id
And ro_hist.is_ssas = 0
And ro_hist.is_external = 0