Search code examples
sqldb2sql-drop

DB2 Drop table if exists equivalent

I need to drop a DB2 table if it exists, or drop and ignore errors.

Solution

  • First query if the table exists, like

    select tabname from syscat.tables where tabschema='myschema' and tabname='mytable'

    and if it returns something issue your

    drop table myschema.mytable

    Other possibility is to just issue the drop command and catch the Exception that will be raised if the table does not exist. Just put that code inside try {...} catch (Exception e) { // Ignore } block for that approach.