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

create foreign key only if it doesn't exits

Hello ,

is there any way to achieve the following in vertica?

alter table add constraint fk_table IF NOT EXISTS foreign key (col) references ....;


  • I was able to acheive this by using the following approach 

    \set fk_sql  'vsql -t -c "SELECT decode(count(*),0,'alter table temp2 ADD CONSTRAINT FK_TEMP2    FOREIGN KEY (ID)  REFERENCES TEMP1(ID)',null) as Cnt FROM v_catalog.constraint_columns where table_name='temp2' and constraint_name='temp_fk' ;"'

     --- execute the sql stored in variable


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.