`information_schema.routines.routine_body`

mysql

type: VARCHAR NOT NULL

5.7-8

type: NULL

Note:

Always SQL.

5.1-10.8

type: VARCHAR NOT NULL

Note:

Always SQL.

type: CHARACTER_DATA NULL

Note:

If the function is an SQL function, then SQL, else EXTERNAL.

10-15

type: CHARACTER_DATA

Note:

If the function is an SQL function, then SQL, else EXTERNAL.

7.4-9.6

type: NULL

Note:

Always NULL.

type: NVARCHAR(30) NULL

Note:

Returns SQL for a Transact-SQL function and EXTERNAL for an externally written function. Functions will always be SQL.