CREATE FUNCTION

Applies to ❌ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The CREATE FUNCTION statement allows for creating stored functions in your catalog.

A stored function, as opposed to a stored procedure, can be used in SQL statements as a scalar column expression, specifically a user defined function, or as a table expression, specifically a table valued functions.

Table of contents

3.4.3.3.1.

Scalar functions (new)

3.4.3.3.2.

CREATE OR REPLACE FUNCTION (new)

3.4.3.3.3.

SQL data access characteristics (new)

3.4.3.3.4.

DETERMINISTIC characteristic (new)

3.4.3.3.5.

ON NULL INPUT characteristic (new)