repo.RepoObject_wo_referencing - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: B90BC0EB-B301-EC11-8510-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject_wo_referencing

Columns

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

bit

NULL

int

NOT NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

int

NULL

nvarchar(128)

NOT NULL

char(2)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_wo_referencing

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_wo_referencing

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_wo_referencing

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_wo_referencing

Column Reference Diagram

entity_1_1_colref-repo.repoobject_wo_referencing

Indexes

idx_RepoObject_wo_referencing__1

idx_RepoObject_wo_referencing__2

Column Details

_

is_repo_managed

is_repo_managed

bit

NULL

Referenced Columns

is_RepoObject_name_uniqueidentifier

is_RepoObject_name_uniqueidentifier

int

NOT NULL

Description

(case when TRY_CAST([RepoObject_name] AS [uniqueidentifier]) IS NULL then (0) else (1) end)


RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

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


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

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


RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

Referenced Columns

RepoObject_Referencing_Count

RepoObject_Referencing_Count

int

NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObject_type

RepoObject_type

char(2)

NOT NULL

Referenced Columns

sql_modules_definition

repo.RepoObject_wo_referencing - V script
CREATE View repo.RepoObject_wo_referencing
As
Select
    T1.RepoObject_guid
  , T1.is_repo_managed
  , T1.RepoObject_name
  , T1.RepoObject_Referencing_Count
  , T1.RepoObject_schema_name
  , T1.RepoObject_type
  , T1.is_RepoObject_name_uniqueidentifier
  , T1.RepoObject_fullname
  , T1.RepoObject_fullname2
From
    repo.RepoObject  As T1
    Left Join
        configT.type As T3
            On
            T3.type = T1.RepoObject_type
Where
    Not Exists
(
    Select
        Expr1 = 1
    From
        reference.RepoObject_reference_T As T2
    Where
        ( T2.referenced_RepoObject_guid = T1.RepoObject_guid )
)
    And T3.is_DocsOutput = 1