sqlparse.RepoObject_SqlModules_43_from_Identifier

Description

Examples

Entity Diagram

Columns

Table 1. Columns of sqlparse.RepoObject_SqlModules_43_from_Identifier - V
Column Name	Data Type	NULL?
alias	`nvarchar(max)`	`NULL`
class	`nvarchar(500)`	`NULL`
json_key	`nvarchar(4000)`	`NOT NULL`
lag_normalized_wo_nolock	`nvarchar(max)`	`NULL`
name	`nvarchar(max)`	`NULL`
name_charindex_dot	`bigint`	`NULL`
name_PostDot	`nvarchar(max)`	`NULL`
name_PreDot	`nvarchar(max)`	`NULL`
RepoObject_guid	`uniqueidentifier`	`NOT NULL`
RowNumber_per_Object	`bigint`	`NULL`
SysObject_fullname	`nvarchar(261)`	`NULL`
T1_identifier_alias	`nvarchar(max)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

sqlparse.RepoObject_SqlModules_42_from_Identifier - V

Referencing Objects

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_RepoObject_SqlModules_43_from_Identifier__1

IndexSemanticGroup: no_group
- [column-RepoObject_guid]; uniqueidentifier
- [column-json_key]; nvarchar(4000)
PK, Unique, Real: 0, 0, 0

idx_RepoObject_SqlModules_43_from_Identifier__2

IndexSemanticGroup: no_group
- [column-RepoObject_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

Column Details

_

alias

nvarchar(max)

NULL

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.alias

class

nvarchar(500)

NULL

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.class

json_key

nvarchar(4000)

NOT NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.json_key

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.json_key

lag_normalized_wo_nolock

nvarchar(max)

NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.lag_normalized_wo_nolock

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.lag_normalized_wo_nolock

name

nvarchar(max)

NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.name

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.name

name_charindex_dot

bigint

NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.name_charindex_dot

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.name_charindex_dot

name_PostDot

nvarchar(max)

NULL

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.name_PostDot

name_PreDot

nvarchar(max)

NULL

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.name_PreDot

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.RepoObject_guid

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.RepoObject_guid

RowNumber_per_Object

bigint

NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.RowNumber_per_Object

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.RowNumber_per_Object

SysObject_fullname

nvarchar(261)

NULL

Description

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

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.SysObject_fullname

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.SysObject_fullname

T1_identifier_alias

nvarchar(max)

NULL

Referenced Columns

sqlparse.RepoObject_SqlModules_42_from_Identifier.T1_identifier_alias

Referencing Columns

sqlparse.RepoObject_SqlModules_44_from_Identifier_QuoteName.T1_identifier_alias

sql_modules_definition

sqlparse.RepoObject_SqlModules_43_from_Identifier - V script

CREATE View sqlparse.RepoObject_SqlModules_43_from_Identifier
As
Select
    --
    RepoObject_guid
  , json_key
  , SysObject_fullname
  , class
  , RowNumber_per_Object
  , name
  , name_charindex_dot
  , name_PreDot             = Case
                                  When name_charindex_dot > 1
                                      Then
                                      Left(name, name_charindex_dot - 1)
                              End
  , name_PostDot            = Case
                                  When name_charindex_dot > 1
                                      Then
                                      Substring ( name, name_charindex_dot + 1, Len ( name ))
                              End
  , alias
  , T1_identifier_alias
  , lag_normalized_wo_nolock
From
    sqlparse.RepoObject_SqlModules_42_from_Identifier