`information_schema.routines.routine_type`

mysql

type: ENUM NOT NULL

5.7-8

type: NULL

Note:

Whether the routine is a PROCEDURE or a FUNCTION.

5.1-10.8

type: VARCHAR NOT NULL

Note:

Whether the routine is a PROCEDURE or a FUNCTION.

type: CHARACTER_DATA NULL

Note:

FUNCTION for a function, PROCEDURE for a procedure

11-15

Note:

Always FUNCTION (In the future there might be other types of routines.)

type: CHARACTER_DATA

Note:

Always FUNCTION (In the future there might be other types of routines.)

7.4-9.6

type: NULL

Note:

Always NULL.

type: NVARCHAR(20) NULL

Note:

Returns PROCEDURE for stored procedures, and FUNCTION for functions.