repo.RepoObject_fullname_u_v - V

type: V ( view ), modify_date: 2021-08-17 19:48:54

RepoObject_guid: 08DF2FE1-AE7A-EB11-84E5-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject_fullname_u_v

Columns

Table 1. Columns of repo.RepoObject_fullname_u_v - V
PK Column Name Data Type NULL? ID

1

nvarchar(261)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_fullname_u_v

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_fullname_u_v

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_fullname_u_v

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_fullname_u_v

Column Reference Diagram

entity_1_1_colref-repo.repoobject_fullname_u_v

Indexes

PK_RepoObject_fullname_u_v

Column Details

_

RepoObject_fullname

1

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

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


sql_modules_definition

repo.RepoObject_fullname_u_v - V script
CREATE View repo.RepoObject_fullname_u_v
As
Select
    RepoObject_fullname
From
    repo.RepoObject
Where
    RepoObject_type In
    ( 'u', 'v' )