Hi, does anybody know how to delete a table using dal.py? I need to provide users with the choice of starting a process from scratch (and over and over again until satisfied). Which means on the first go, a user who is defining some steps in a software build setup, may be configuring, let' call call it step_E, which cause a table to be created @ runtime. Then as the user is continuing to setup and tweak his build setup, he may decide that step_F is better suited. Since these tables are created on the fly and that step_E is being replaced with step_F, the step_E table needs to disappear. So, is their a way to not just drop the records, but he entire table it self? if not when all tables get delivered as part of the overall build reports, then the testers will look at the contents and see an empty container (the step_E table)... from experience, this type of confusion never, ever, goes away. so to have a method to look at the set of generated tables, and remove those not listed is the best remedy.
And, if I tell them to blow away the entire staging area and start over, there will be some panic ;) So, we keep the good tables where we don't update/insert if nothing new and delete the bad tables... Can anyone help? Again,any help is appreciated, Thanks, Mart :)