Alter Table is column exists
Posted: Thu Jul 09, 2015 3:49 pm
Hello
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.
Thank you
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;