information_schema.routines.schema_level_routine

mysql

mariadb

tidb

postgres

type: YES_OR_NO NULL
Note:
Always YES (The opposite would be a method of a user-defined type, which is a feature not available in PostgreSQL.)
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
Always YES (The opposite would be a method of a user-defined type, which is a feature not available in PostgreSQL.)
© 1996-2022 The PostgreSQL Global Development Group
7.4-9.6

cockroachdb

type: NULL
Note:
Always NULL.
© 2022 CockroachDB
20.1-21.1

mssql

type: NVARCHAR(10) NULL
Note:
Returns YES if schema-level function, or NO if not a schema-level function. Always returns YES.
© Microsoft 2022
aps-pdw-2016-sql-server-ver15