The Information Schema consists of a standardized set of views that contain information about the objects defined in the current database. The Information Schema is defined in the ISO/IEC 9075-11 standard and can therefore be expected to be portable and remain stable.
The Information Schema views do not contain information about all MonetDB-specific features; to inquire those you need to query the system catalog tables or views. To support efficient joins between Information Schema views and system catalog tables or views, the Information Schema views have been extended (after the ISO standard columns) with MonetDB system catalog id columns such as schema_id, table_id, column_id, function_id, etc.
The Information Schema itself is a system schema named information_schema. This schema automatically exists in every database from release v11.49 (Dec2023). By default, the information_schema is not in the schema search path, so you need to access all objects in it through qualified names as shown in the example queries below.
SELECT * FROM information_schema.character_sets;
SELECT * FROM information_schema.schemata;
SELECT * FROM information_schema.tables;
SELECT * FROM information_schema.views;
SELECT * FROM information_schema.columns;
SELECT * FROM information_schema.table_constraints;
SELECT * FROM information_schema.referential_constraints;
SELECT * FROM information_schema.check_constraints;
SELECT * FROM information_schema.routines;
SELECT * FROM information_schema.parameters;
SELECT * FROM information_schema.sequences;