USP_SMARTFIELDPROCEDURE_GETINFORMATION

CREATE procedure dbo.USP_SMARTFIELDPROCEDURE_GETINFORMATION
(
    @ID as uniqueidentifier
)
as
    select
        SMARTFIELDCATALOG.ID as SMARTFIELDCATALOGID,
        SMARTFIELDCATALOG.DATATYPECODE as SMARTFIELDDATATYPECODE,
        SMARTFIELDCATALOG.FORMMETADATAXML as SMARTFIELDFORMMETADATAXML,
        SMARTFIELDCATALOG.DISPLAYNAME as SMARTFIELDDISPLAYNAME,
        SMARTFIELDCATALOG.RECORDTYPEID as SMARTFIELDRECORDTYPEID,
        [SMARTFIELDCATALOG].[VALUERECORDTYPEID] as [SMARTFIELDVALUERECORDTYPEID],
        SMARTFIELDCATALOG.HASSITEFILTER
    from
        dbo.SMARTFIELDCATALOG
    where
        SMARTFIELDCATALOG.ID = @ID;