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 ? 

Comments

  • 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
Emoji
Image
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.