USP_QUERYVIEW_GETLINKINFO
Returns link information between two query views.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OBJECTNAME | nvarchar(128) | IN | |
| @PATHALIAS | nvarchar(128) | IN |
Definition
Copy
CREATE procedure dbo.[USP_QUERYVIEW_GETLINKINFO]
(
@OBJECTNAME nvarchar(128),
@PATHALIAS nvarchar(128)
)
as
set nocount on;
select
[RELATEDVIEW].[OBJECTNAME],
[ROOTCOLUMN],
[RELATEDCOLUMN],
[JOINTYPE],
[JOINPARAMETERS],
[CARDINALITYTYPE]
from dbo.[QUERYVIEWRELATIONSHIP]
join dbo.[QUERYVIEWCATALOG] [ROOTVIEW] on dbo.[QUERYVIEWRELATIONSHIP].[ROOTQUERYVIEWID] = [ROOTVIEW].[ID]
join dbo.[QUERYVIEWCATALOG] [RELATEDVIEW] on dbo.[QUERYVIEWRELATIONSHIP].[RELATEDQUERYVIEWID] = [RELATEDVIEW].[ID]
where [ROOTVIEW].[OBJECTNAME] = @OBJECTNAME and [PATHALIAS] = @PATHALIAS;