UFN_DATAFORMTEMPLATE_ISVALID_REQUIREDFIELDCONSTRAINT

        create function [dbo].[UFN_DATAFORMTEMPLATE_ISVALID_REQUIREDFIELDCONSTRAINT](@TABLENAME nvarchar(128), @FIELDNAME nvarchar(128))
        returns BIT 
        as
        begin

        if exists(select sc.object_id from sys.columns sc
            inner join sys.tables st on st.object_id=sc.object_id
            where sc.is_NULLABLE=0
            and st.name=@TABLENAME
            and sc.name=@FIELDNAME
        ) return 1;

        return 0;

        end