information_schema.parameters.parameter_mode

mysql

type: VARCHAR NULL
5.7-8

mariadb

type: NULL
Note:
One of IN, OUT, INOUT or NULL for RETURNS.
© 2022 MariaDB
5.1-10.8

tidb

postgres

type: CHARACTER_DATA NULL
Note:
IN for input parameter, OUT for output parameter, and INOUT for input/output parameter.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
IN for input parameter, OUT for output parameter, and INOUT for input/output parameter.
© 1996-2022 The PostgreSQL Global Development Group
8.2-9.6
Note:
Always IN, meaning input parameter (in the future there might be other parameter modes)
© 1996-2022 The PostgreSQL Global Development Group
8-8.1
Note:
Always IN, meaning input parameter (In the future there might be other parameter modes.)
© 1996-2022 The PostgreSQL Global Development Group
7.4

cockroachdb

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

mssql

type: NVARCHAR(10) NULL
Note:
Returns IN if an input parameter, OUT if an output parameter, and INOUT if an input/output parameter.
© Microsoft 2022
aps-pdw-2016-sql-server-ver15