How to determine if the Table exists in the Database or not

Oracle - select table_name from user_tables where table_name = upper('table_name_to_be_searched');

SQL Server - select name from sys.tables where name = upper('table_name_to_be_searched');