sqlparse.RepoObject_SqlModules_52_Identitfier_QuoteName - V

type: V ( view ), modify_date: 2021-08-17 20:15:05

RepoObject_guid: 2E454A02-8364-EB11-84DD-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_52_identitfier_quotename

Columns

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

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(4000)

NOT NULL

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

bigint

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_52_identitfier_quotename

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_52_identitfier_quotename

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_52_identitfier_quotename

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_52_identitfier_quotename

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_52_identitfier_quotename

Indexes

idx_RepoObject_SqlModules_52_Identitfier_QuoteName__1

idx_RepoObject_SqlModules_52_Identitfier_QuoteName__2

Column Details

_

child0_class

child0_class

nvarchar(500)

NULL

children

children

nvarchar(max)

NULL

class

class

nvarchar(500)

NULL

is_group

is_group

bit

NULL

is_keyword

is_keyword

bit

NULL

is_whitespace

is_whitespace

bit

NULL

json_key

json_key

nvarchar(4000)

NOT NULL

normalized

normalized

nvarchar(max)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RowNumber_per_Object

RowNumber_per_Object

bigint

NULL

source_column

source_column

nvarchar(max)

NULL

source_column_QuoteName

source_column_QuoteName

nvarchar(max)

NULL

source_table

source_table

nvarchar(max)

NULL

source_table_QuoteName

source_table_QuoteName

nvarchar(max)

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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


sql_modules_definition

sqlparse.RepoObject_SqlModules_52_Identitfier_QuoteName - V script
CREATE View sqlparse.RepoObject_SqlModules_52_Identitfier_QuoteName
As
Select
    --
    RepoObject_guid
  , json_key
  , SysObject_fullname
  , RowNumber_per_Object
  , class
  , normalized
  , is_group
  , is_keyword
  , is_whitespace
  , source_table
  , source_column
  , source_table_QuoteName  = Case
                                  When Left(source_table, 1) = '['
                                       And Right(source_table, 1) = ']'
                                      Then
                                      source_table
                                  Else
                                      QuoteName ( source_table )
                              End
  , source_column_QuoteName = Case
                                  When Left(source_column, 1) = '['
                                       And Right(source_column, 1) = ']'
                                      Then
                                      source_column
                                  Else
                                      QuoteName ( source_column )
                              End
  , children
  , child0_class
From
    sqlparse.RepoObject_SqlModules_51_Identitfier