Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Identify tables without primary key

How to identify list of tables with doesnt have PK in its DDL ? 


  • Did you check


    select * from v_catalog.tables t where t.table_name not in
    select table_name from v_catalog.primary_keys



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.