List most referenced tables in Vertica database (by FK)

Query below lists tables that are most referenced by other tables with foreign keys.

See also:


select reference_table_schema || '.' || reference_table_name
            as table,
       count(*) as references,
       count(distinct table_schema ||'.'|| table_name) as referencing_tables
from v_catalog.foreign_keys
group by reference_table_schema,
order by reference_table_schema,


  • table - name of the table with schema name
  • references - number of foreign keys referencing to this table
  • referencing_tables - number of different tables referencing to this table


  • One row represents one table in a database
  • Scope of rows: tables being used in foreign keys as primary key table
  • Ordered by number of references descending

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.