I am trying to create a procedure that contains a while loop to continuously run several updates/drop tables/create tables based on some conditions that are calculated at the end. If the conditions (based on the last tables that are created) are not met, the loop continues to run.
Whenever I go to execute the Create Procedure code, It come sup with 4 errors all pertaining to the existence of certain tables that it drops and creates new versions of.
My questions I suppose are:
1. Why If I am just running a 'Create Procedure' does it care about the existence of those tables?
2. Is there an issue with dropping/creating tables in a 'while' environment that I am unaware of?
3. Is there an issue with dropping/creating tables in a 'Create Procedure' Environment?