This statement defines a comment on the SQL function SpecificUDF1. Note that you must specify a specific UDF name.
COMMENT ON FUNCTION SpecificUDF1 AS 'This is an SQL user-defined function';
Because the object kind for this request is FUNCTION, you must specify the keyword FUNCTION for the object kind when you code it.