alter table if exists

Hello

 

I'm trying to see if a column exists in a vertica table and dropping if it does.

For Example this could look like the following in PostgreSQL:

 

ALTER TABLE PORTALIQ.dimSourceTypeS DROP COLUMN IF EXISTS SourceKey;

Can anyone help please?

Thanks

Comments

Leave a Comment

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