sqlparse.RepoObject_SqlModules_79_reference_union

Description

Examples

Entity Diagram

Columns

Table 1. Columns of sqlparse.RepoObject_SqlModules_79_reference_union - V
Column Name	Data Type	NULL?
alias_QuoteName	`nvarchar(max)`	`NULL`
normalized	`nvarchar(max)`	`NULL`
RepoObject_guid	`uniqueidentifier`	`NOT NULL`
RepoObjectColumn_guid	`uniqueidentifier`	`NOT NULL`
RepoObjectColumn_name	`nvarchar(128)`	`NOT NULL`
source_column_QuoteName	`nvarchar(max)`	`NULL`
source_RepoObject_guid	`uniqueidentifier`	`NOT NULL`
source_RepoObjectColumn_guid	`uniqueidentifier`	`NOT NULL`
source_RepoObjectColumn_name	`nvarchar(128)`	`NOT NULL`
source_SysObject_fullname	`nvarchar(261)`	`NOT NULL`
source_table_QuoteName	`nvarchar(max)`	`NULL`
SysObject_fullname	`nvarchar(261)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

Referencing Objects

reference.RepoObjectColumn_reference_SqlModules - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

alias_QuoteName

nvarchar(max)

NULL

normalized

nvarchar(max)

NULL

Referencing Columns

reference.RepoObjectColumn_reference_SqlModules.definition

RepoObject_guid

uniqueidentifier

NOT NULL

Referencing Columns

reference.RepoObjectColumn_reference_SqlModules.referencing_RepoObject_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Referencing Columns

reference.RepoObjectColumn_reference_SqlModules.referencing_RepoObjectColumn_guid

RepoObjectColumn_name

nvarchar(128)

NOT NULL

source_column_QuoteName

nvarchar(max)

NULL

source_RepoObject_guid

uniqueidentifier

NOT NULL

Referencing Columns

reference.RepoObjectColumn_reference_SqlModules.referenced_RepoObject_guid

source_RepoObjectColumn_guid

uniqueidentifier

NOT NULL

Referencing Columns

reference.RepoObjectColumn_reference_SqlModules.referenced_RepoObjectColumn_guid

source_RepoObjectColumn_name

nvarchar(128)

NOT NULL

source_SysObject_fullname

nvarchar(261)

NOT NULL

source_table_QuoteName

nvarchar(max)

NULL

SysObject_fullname

nvarchar(261)

NULL

Referencing Columns

reference.RepoObjectColumn_reference_SqlModules.SysObject_fullname

sql_modules_definition

sqlparse.RepoObject_SqlModules_79_reference_union - V script

CREATE View sqlparse.RepoObject_SqlModules_79_reference_union
As
Select
    RepoObject_guid
  , alias_QuoteName
  , SysObject_fullname
  , RepoObjectColumn_guid
  , RepoObjectColumn_name
  , source_RepoObject_guid
  , source_SysObject_fullname
  , source_RepoObjectColumn_guid
  , source_RepoObjectColumn_name
  , source_table_QuoteName
  , source_column_QuoteName
  , normalized
From
    sqlparse.RepoObject_SqlModules_71_reference_ExpliciteTableAlias
Union All
Select
    RepoObject_guid
  , alias_QuoteName
  , SysObject_fullname
  , RepoObjectColumn_guid
  , RepoObjectColumn_name
  , source_RepoObject_guid
  , source_SysObject_fullname
  , source_RepoObjectColumn_guid
  , source_RepoObjectColumn_name
  , source_table_QuoteName
  , source_column_QuoteName
  , normalized
From
    sqlparse.RepoObject_SqlModules_72_reference_NoTableAlias