Find tables without primary keys (PKs) in Vertica database

Query below lists tables in a database without primary keys.


select tab.table_schema,
from v_catalog.tables tab
left join v_catalog.primary_keys pk
          on tab.table_schema = pk.table_schema
          and tab.table_name = pk.table_name
where pk.constraint_id is null
order by tab.table_schema,


  • table_schema - schema name
  • table_name - table name


  • One row represents one table in a database without primary key
  • Scope of rows: all tables without primary keys in a database
  • Ordered by schema, table name

Sample results

Below is a list of tables in Vertica database without primary keys. Is that a lot? Check out here.

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.