sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName - V

type: V ( view ), modify_date: 2021-08-17 20:14:09

RepoObject_guid: 5C4241CB-FB63-EB11-84DD-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_44_from_identifier_quotename

Columns

Table 1. Columns of sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(4000)

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

bigint

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

bigint

NULL

nvarchar(261)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_44_from_identifier_quotename

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_44_from_identifier_quotename

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_44_from_identifier_quotename

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_44_from_identifier_quotename

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_44_from_identifier_quotename

Indexes

idx_RepoObject_SqlModules_44_from_Identifier_QuoteName__1

idx_RepoObject_SqlModules_44_from_Identifier_QuoteName__2

Column Details

_

alias

alias

nvarchar(max)

NULL

alias_QuoteName

alias_QuoteName

nvarchar(max)

NULL

class

class

nvarchar(500)

NULL

json_key

json_key

nvarchar(4000)

NOT NULL

lag_normalized_wo_nolock

lag_normalized_wo_nolock

nvarchar(max)

NULL

name

name

nvarchar(max)

NULL

name_charindex_dot

name_charindex_dot

bigint

NULL

name_PostDot

name_PostDot

nvarchar(max)

NULL

name_PostDot_QuoteName

name_PostDot_QuoteName

nvarchar(max)

NULL

name_PreDot

name_PreDot

nvarchar(max)

NULL

name_PreDot_QuoteName

name_PreDot_QuoteName

nvarchar(max)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RowNumber_per_Object

RowNumber_per_Object

bigint

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


T1_identifier_alias

T1_identifier_alias

nvarchar(max)

NULL

sql_modules_definition

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName - V script
CREATE View sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName
As
Select
    --
    T1.RepoObject_guid
  , T1.json_key
  , T1.SysObject_fullname
  , T1.class
  , T1.RowNumber_per_Object
  , T1.name
  , T1.name_charindex_dot
  , T1.name_PreDot
  , T1.name_PostDot
  , T1.alias
  , T1.T1_identifier_alias
  , T1.lag_normalized_wo_nolock
  , alias_QuoteName        = Case
                                 When Left(T1.alias, 1) = '['
                                      And Right(T1.alias, 1) = ']'
                                     Then
                                     T1.alias
                                 Else
                                     QuoteName ( T1.alias )
                             End
  , name_PreDot_QuoteName  = Case
                                 When Left(T1.name_PreDot, 1) = '['
                                      And Right(T1.name_PreDot, 1) = ']'
                                     Then
                                     T1.name_PreDot
                                 Else
                                     QuoteName ( T1.name_PreDot )
                             End
  , name_PostDot_QuoteName = Case
                                 When Left(T1.name_PostDot, 1) = '['
                                      And Right(T1.name_PostDot, 1) = ']'
                                     Then
                                     T1.name_PostDot
                                 Else
                                     QuoteName ( T1.name_PostDot )
                             End
From
    sqlparse.RepoObject_SqlModules_43_from_Identifier As T1