information_schema.table_privileges.with_hierarchy

mysql

mariadb

tidb

postgres

type: YES_OR_NO NULL
Note:
In the SQL standard, WITH HIERARCHY OPTION is a separate (sub-)privilege allowing certain operations on table inheritance hierarchies. In PostgreSQL, this is included in the SELECT privilege, so this column shows YES if the privilege is SELECT, else NO.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: YES_OR_NO
Note:
In the SQL standard, WITH HIERARCHY OPTION is a separate (sub-)privilege allowing certain operations on table inheritance hierarchies. In PostgreSQL, this is included in the SELECT privilege, so this column shows YES if the privilege is SELECT, else NO.
© 1996-2022 The PostgreSQL Global Development Group
9.2-9.6
type: CHARACTER_DATA
Note:
Applies to a feature not available in PostgreSQL
© 1996-2022 The PostgreSQL Global Development Group
7.4-9.1

cockroachdb

type: unknown
Note:
Always NULL (unsupported by CockroachDB).
© 2022 CockroachDB
1-21.2

mssql