information_schema

Materialize has compatibility shims for the following relations from the SQL standard information_schema schema, which is automatically available in all databases:

• applicable_roles
• character_sets
• columns
• enabled_roles
• key_column_usage
• referential_constraints
• role_table_grants
• routines
• schemata
• tables
• table_constraints
• table_privileges
• triggers
• views

These compatibility shims are largely incomplete. Most are lacking some columns that are present in the SQL standard, or if they do include the column the result set its value may always be NULL. The precise nature of the incompleteness is intentionally undocumented. New tools developed against Materialize should use the documented mz_catalog API instead.