Skip to main content

SQL System Catalog

A relational database system uses a system catalog to store information on database objects, such as tables, columns, functions, procedures, users. The MonetDB SQL system catalog is a collection of regular mostly readonly system tables and system views located in the schemas "sys" and "tmp". The relations are modified indirectly through SQL commands such as CREATE TABLE. Some system views are implemented as wrappers around table producing system functions to present internal bookkeeping information.

Below you find categories of system tables and views currently provided.

Tip: to find out which system tables and views are available in your database run query:
  SELECT schema_id, name, type, substring(query, 0, 50) as query FROM sys.tables WHERE system ORDER BY schema_id, name;