alter table if exists

richie1

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

[Deleted User]

Sorry, we don't have that functionality.