config.ftv_dwh_database - IF

type: IF ( inline function ), modify_date: 2021-08-11 13:00:06

RepoObject_guid: 2790291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

Columns

Table 1. Columns of config.ftv_dwh_database - IF
PK	Column Name	Data Type	NULL?	ID
	dwh_database_id	`smallint`	`NULL`
	dwh_database_name	`nvarchar(128)`	`NULL`

References

Referenced Objects

config.Parameter - U

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

dwh_database_id

smallint

NULL

dwh_database_name

nvarchar(128)

NULL

sql_modules_definition

config.ftv_dwh_database - IF script

CREATE Function [config].ftv_dwh_database
()
--returns nvarchar(128)
Returns Table
As
Return
(
    Select
        Cast([Parameter_value_result] As NVarchar(128))          As dwh_database_name
      , Db_Id ( Cast([Parameter_value_result] As NVarchar(128))) As dwh_database_id
    From
        [config].Parameter
    Where
        Parameter_name    = 'dwh_database_name'
        And sub_Parameter = N''
);