Drop if exists in netezza

if-statement exists netezza
Harry picture Harry · Oct 29, 2014 · Viewed 9.9k times · Source

I need a command to delete a table if that exists in NETEZZA, Something like that:

drop table if exists xxx;

I have searched and tried many but it didn't work. Can you help me here?

Answer

Niederee picture Niederee · Jul 1, 2016

In netezza you can use this syntax:

drop table table_name if exists;

Related questions

SQL Server: IF EXISTS ; ELSE

I have a tableA: ID value 1 100 2 101 2 444 3 501 Also TableB ID Code 1 2 Now I want to populate col = code of table B if there exists ID = 2 in tableA. for multiple values , get max value. else populate it with '123'. Now here …

Read More
Oracle sql return true if exists question

How do I check if a particular element exists in a table - how can I return true or false? I have a table that has user_id user_password user_secretQ Verbally, I want to do this: If a …

Read More
JavaScript if var exists

I want my code so that if a specific var exists it will perform an action, else it will be ignored and move along. The problem with my code is, if the specific var does not exist it causes an …

Read More