UFN_CLOUDCATALOG_GETURLFROMID

Returns the URL used to access the cloud catalog given the catalog ID

Return

Return Type
UDT_WEBADDRESS

Parameters

Parameter Parameter Type Mode Description
@CATALOGID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_CLOUDCATALOG_GETURLFROMID
    (
    @CATALOGID uniqueidentifier
    )
returns dbo.UDT_WEBADDRESS
with execute as caller
as begin
    declare @URL dbo.UDT_WEBADDRESS
    select @URL = URL from dbo.CLOUDCATALOGDEFINITION where ID = @CATALOGID
    return @URL
end