How to skip steps in SQL code
Hi,
I have a SQL code where there are steps like creation of table follwed by delete data from the table. For the first time when we run the code, the create table runs well. For the second time if the table in the create script already exist how do we check that and skip that statement to go to the next step which is DELETE step.
For eg:
Create table x;
delete x;
IF table x already exists what should be done to check if it already exist and go to the next DELETE step.
Thanks,
Saran.