System Catalog / Data Dictionary Views in relational databases (RDBMS)

Piotr Kononow - Dataedo Team Piotr Kononow 2018-09-30

Table of Contents:

    (System) Catalog Views or Data Dictionary Views (or sometimes tables) are standard views (or tables) in most relational databases that provide access to metadata - information about schema, security, etc. Each engine has its specific set of views.

    Read also: Information_schema

    Typical views

    • tables
    • columns
    • foreign keys

    See more in: Metadata in relational databases

    Database catalogs

    Database Catalog Schema Prefix
    SQL Server System Catalog Views sys
    Azure SQL Database System Catalog Views sys
    Oracle Data Dictionary Views / Catalog Views SYS ALL_, USER_, DBA_
    MySQL Information schema information_schema
    PostgreSQL System Catalogs pg_
    IBM Db2 Catalog views SYSCAT
    MariaDB Information schema information_schema
    Amazon Redshift System Catalog Tables pg_
    Teradata Data Dictionary Views DBC
    Snowflake Information schema information_schema
    SAP/Sybase ASE System Tables sys
    SAP HANA System Views sys
    Vertica System Tables v_catalog
    IBM Informix System Catalog Table informix sys
    SQLite System Table sqlite_master
    Firebird System Tables RDB$
    Interbase System Tables RDB$
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).