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.6.3.3.1.

Scalar functions

3.6.3.3.2.

CREATE OR REPLACE FUNCTION

3.6.3.3.3.

SQL data access characteristics

3.6.3.3.4.

DETERMINISTIC characteristic

3.6.3.3.5.

ON NULL INPUT characteristic