Skip to main content

alter table if exists

  • July 9, 2015
  • 1 reply
  • 6 views
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

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • July 10, 2015

    Sorry, we don't have that functionality.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement