USP_PAGEDEFINITION_GETMETADATA

CREATE procedure USP_PAGEDEFINITION_GETMETADATA    

    @PAGEID uniqueidentifier

    as 

    set nocount on;

    select    RECORDTYPE.NAME as CONTEXTRECORDTYPE,
            PAGEDEFINITIONCATALOG.PAGEDEFINITIONSPEC,
            PAGEDEFINITIONCATALOG.TSLONG,
            PAGEDEFINITIONCATALOG.EXPRESSIONDATAFORMID as PAGEEXPRESSIONDATAFORMID

            from dbo.PAGEDEFINITIONCATALOG 
            left outer join dbo.RECORDTYPE on PAGEDEFINITIONCATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID

            where PAGEDEFINITIONCATALOG.ID = @PAGEID;

    return 0;