sqlparse.RepoObject_SqlModules_26_IdentifierList_children_IdentifierSplit_QuoteName - V

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

RepoObject_guid: 0C813EBD-7764-EB11-84DD-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_26_identifierlist_children_identifiersplit_quotename

Columns

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

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NOT NULL

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

bigint

NULL

nvarchar(261)

NULL

nvarchar(500)

NULL

nvarchar(4000)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_26_identifierlist_children_identifiersplit_quotename

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_26_identifierlist_children_identifiersplit_quotename

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_26_identifierlist_children_identifiersplit_quotename

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_26_identifierlist_children_identifiersplit_quotename

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_26_identifierlist_children_identifiersplit_quotename

Indexes

idx_RepoObject_SqlModules_26_IdentifierList_children_IdentifierSplit_QuoteName__1

idx_RepoObject_SqlModules_26_IdentifierList_children_IdentifierSplit_QuoteName__2

idx_RepoObject_SqlModules_26_IdentifierList_children_IdentifierSplit_QuoteName__3

Column Details

_

class

class

nvarchar(500)

NULL

Identifier_alias

Identifier_alias

nvarchar(max)

NULL

Identifier_alias_QuoteName

Identifier_alias_QuoteName

nvarchar(max)

NULL

Identifier_source

Identifier_source

nvarchar(max)

NULL

Identifier_source_children

Identifier_source_children

nvarchar(max)

NULL

Identifier_source_class

Identifier_source_class

nvarchar(500)

NULL

Identifier_source_column

Identifier_source_column

nvarchar(4000)

NULL

Identifier_source_column_QuoteName

Identifier_source_column_QuoteName

nvarchar(4000)

NULL

Identifier_source_table

Identifier_source_table

nvarchar(4000)

NULL

Identifier_source_table_QuoteName

Identifier_source_table_QuoteName

nvarchar(4000)

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

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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


T2_class

T2_class

nvarchar(500)

NULL

T2_json_key

T2_json_key

nvarchar(4000)

NOT NULL

sql_modules_definition

sqlparse.RepoObject_SqlModules_26_IdentifierList_children_IdentifierSplit_QuoteName - V script
CREATE View sqlparse.RepoObject_SqlModules_26_IdentifierList_children_IdentifierSplit_QuoteName
As
Select
    RepoObject_guid
  , json_key
  , T2_json_key
  , SysObject_fullname
  , RowNumber_per_Object
  , class
  , normalized
  , T2_class
  , Identifier_alias
  , Identifier_source
  , Identifier_source_class
  , Identifier_source_children
  , Identifier_source_table
  , Identifier_source_column
  , Identifier_alias_QuoteName         = Case
                                             When Left(Identifier_alias, 1) = '['
                                                  And Right(Identifier_alias, 1) = ']'
                                                 Then
                                                 Identifier_alias
                                             Else
                                                 QuoteName ( Identifier_alias )
                                         End
  , Identifier_source_table_QuoteName  = Case
                                             When Left(Identifier_source_table, 1) = '['
                                                  And Right(Identifier_source_table, 1) = ']'
                                                 Then
                                                 Identifier_source_table
                                             Else
                                                 QuoteName ( Identifier_source_table )
                                         End
  , Identifier_source_column_QuoteName = Case
                                             When Left(Identifier_source_column, 1) = '['
                                                  And Right(Identifier_source_column, 1) = ']'
                                                 Then
                                                 Identifier_source_column
                                             Else
                                                 QuoteName ( Identifier_source_column )
                                         End
From
    sqlparse.RepoObject_SqlModules_25_IdentifierList_children_IdentifierSplit