I'm trying to write SQL script to create tables as follows:
--------------------------------
drop table xxx;
create table xxx (
......
);
grant all on xxx to public;
--------------------------------
Before dropping the table, I'd like to check if the table exists as the
following psuedo code:
if <table exists> drop table xxx;
How can i write this 'if' condition? Or are there any other ways to
check this??
Thanks in advance.