docs.RepoObject_ParameterList - V

type: V ( view ), modify_date: 2021-09-30 18:02:22

RepoObject_guid: 9DDFBE88-CA97-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.repoobject_parameterlist

Columns

Table 1. Columns of docs.RepoObject_ParameterList - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.repoobject_parameterlist

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.repoobject_parameterlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.repoobject_parameterlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.repoobject_parameterlist

Column Reference Diagram

entity_1_1_colref-docs.repoobject_parameterlist

Indexes

PK_RepoObject_ParameterList

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

AntoraParameterList

AntoraParameterList

nvarchar(max)

NULL

sql_modules_definition

docs.RepoObject_ParameterList - V script
/*
[cultures_name] is not part of the key. parameters are the same for all cultures
*/

CREATE View [docs].[RepoObject_ParameterList]
As
Select
    RepoObject_guid     = SysObject_RepoObject_guid
  , AntoraParameterList = String_Agg (
                                         Concat (
                                                    Cast(N'* ' As NVarchar(Max))
                                                  , name
                                                  , ' (' + user_type_fullname + ')'
                                                  , Iif(has_default_value = 1
                                                        , ' = '
                                                          + Try_Cast(default_value As NVarchar(4000))Collate Database_Default
                                                        , Null)
                                                )
                                       , Char ( 13 ) + Char ( 10 )
                                     ) Within Group(Order By
                                                        parameter_id)
From
    repo_sys.parameters
Group By
    SysObject_RepoObject_guid