Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Drop if exists in netezza

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?

like image 571
Harry Avatar asked Dec 01 '22 01:12

Harry


1 Answers

In netezza you can use this syntax:

drop table table_name if exists;
like image 109
Niederee Avatar answered Dec 02 '22 14:12

Niederee