UFN_QUERYVIEWRELATIONSHIP_GETCLONEDRELATIONSHIPS

Gets a list of related query view object names for the specified added by query ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DESTOBJECT	nvarchar(128)	IN
@SOURCEOBJECT	nvarchar(128)	IN

Definition

Copy



create function dbo.UFN_QUERYVIEWRELATIONSHIP_GETCLONEDRELATIONSHIPS(
  @DESTOBJECT nvarchar(128), 
  @SOURCEOBJECT nvarchar(128)
  )
returns table
as
    return (
  select 
    @DESTOBJECT [ROOTQUERYVIEWOBJECTNAME], 
    (select [OBJECTNAME] from dbo.[QUERYVIEWCATALOG] [QVC] where [QUERYVIEWRELATIONSHIP].[RELATEDQUERYVIEWID] = [QVC].[ID]) [RELATEDQUERYVIEWOBJECTNAME],
    [PATHALIAS]
    from dbo.[QUERYVIEWRELATIONSHIP]
    join dbo.[QUERYVIEWCATALOG] [QV] on [QUERYVIEWRELATIONSHIP].[ROOTQUERYVIEWID] = [QV].[ID]
    where [QV].[OBJECTNAME] = @SOURCEOBJECT
      and (
        exists (select [COLUMN_NAME] from INFORMATION_SCHEMA.COLUMNS where [COLUMN_NAME] = [ROOTCOLUMN] and [TABLE_NAME] = @DESTOBJECT)
        or 
        exists (select [COLUMN_NAME] from INFORMATION_SCHEMA.ROUTINE_COLUMNS where [COLUMN_NAME] = [ROOTCOLUMN] and [TABLE_NAME] = @DESTOBJECT)
          ));