graph.RepoObject_S - V

type: V ( view ), modify_date: 2021-08-17 18:49:49

RepoObject_guid: A89FCDB3-3265-EB11-84DD-A81E8446D5B0

Description

Examples

Entity Diagram

entity-graph.repoobject_s

Columns

Table 1. Columns of graph.RepoObject_S - V
PK Column Name Data Type NULL? ID

nvarchar(261)

NOT NULL

nvarchar(257)

NULL

uniqueidentifier

NOT NULL

char(2)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-graph.repoobject_s

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-graph.repoobject_s

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-graph.repoobject_s

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-graph.repoobject_s

Column Reference Diagram

entity_1_1_colref-graph.repoobject_s

Indexes

idx_RepoObject_S__1

Column Details

_

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

RepoObject_type

RepoObject_type

char(2)

NOT NULL

Referenced Columns

sql_modules_definition

graph.RepoObject_S - V script
CREATE View graph.RepoObject_S
As
Select
    --
    RepoObject_guid
  , RepoObject_fullname
  --we need to mark the column as nullable, because in [repo].[usp_sync_guid_RepoObjectColumn] in step 1010 it will be inherited into target: [Repo_is_nullable] = [scroc].[is_nullable]
  , RepoObject_fullname2 = NullIf(RepoObject_fullname2, '')
  , RepoObject_type
From
    repo.RepoObject