I have searched far and wide and I cannot find any code that will allow me to alter a table (drop the column) if the column exists in my HP Vertica database.
Can anyone help me please?
An example of this in postgreSql would look like the following.
Code: Select all
ALTER TABLE PORTALIQ.dimSourceTypeS DROP COLUMN IF EXISTS SourceKey;