USP_SMARTQUERY_GETMETADATA

CREATE procedure dbo.USP_SMARTQUERY_GETMETADATA(@ID uniqueidentifier)
as

select
    SMARTQUERYCATALOG.NAME,
    SMARTQUERYCATALOG.DESCRIPTION,
    SMARTQUERYCATALOG.FILTERFORMDEFINITION,
    SMARTQUERYCATALOG.OUTPUTDEFINITION,
    SMARTQUERYCATALOG.TVFNAME,
    SMARTQUERYCATALOG.TVFPARAMETERLIST,
    SMARTQUERYCATALOG.RECORDTYPEID,
    SMARTQUERYCATALOG.SMARTQUERYSPEC,
    RECORDTYPE.NAME as RECORDTYPE,
    SMARTQUERYCATALOG.HASAPPUSERIDPARAM,
    SMARTQUERYCATALOG.UINAME,
  SMARTQUERYCATALOG.MARTKEY,
  SMARTQUERYCATALOG.TVFSCHEMA
from
    dbo.SMARTQUERYCATALOG
    join dbo.RECORDTYPE on SMARTQUERYCATALOG.RECORDTYPEID = RECORDTYPE.ID
where
    SMARTQUERYCATALOG.ID = @ID;