graph.RepoObjectColumn_S - V

type: V ( view ), modify_date: 2022-01-05 18:06:34

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

Description

Examples

Entity Diagram

entity-graph.repoobjectcolumn_s

Columns

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

nvarchar(261)

NOT NULL

nvarchar(257)

NULL

uniqueidentifier

NOT NULL

char(2)

NOT NULL

nvarchar(520)

NOT NULL

nvarchar(386)

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-graph.repoobjectcolumn_s

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-graph.repoobjectcolumn_s

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-graph.repoobjectcolumn_s

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-graph.repoobjectcolumn_s

Column Reference Diagram

entity_1_1_colref-graph.repoobjectcolumn_s

Indexes

idx_RepoObjectColumn_S__1

idx_RepoObjectColumn_S__2

idx_RepoObjectColumn_S__3

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

RepoObject_type

RepoObject_type

char(2)

NOT NULL

RepoObjectColumn_fullname

RepoObjectColumn_fullname

nvarchar(520)

NOT NULL

RepoObjectColumn_fullname2

RepoObjectColumn_fullname2

nvarchar(386)

NULL

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_name

RepoObjectColumn_name

nvarchar(128)

NOT NULL

RepoObjectColumn_type

RepoObjectColumn_type

nvarchar(128)

NULL

sql_modules_definition

graph.RepoObjectColumn_S - V script
CREATE View [graph].[RepoObjectColumn_S]
As
Select
    --
    RepoObjectColumn_guid
  , RepoObjectColumn_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]
  , RepoObjectColumn_fullname2 = NullIf(RepoObjectColumn_fullname2, '')
  , RepoObjectColumn_name
  , RepoObjectColumn_type      = Repo_user_type_fullname
  , 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.RepoObjectColumn_gross