Forum Discussion
How to delete staging tables?
Thanks, I'll give that a try
I understand if you want to have the least impact on your database then I would suggest that you stick with your current approach.
17MB in size is quite a small model. Considering even in the free version you get 1GB.
What you could also possibly do, is try and Append the data from staging table 2, back into Staging table 1? That could possibly save you some space, as well as data refreshing time.
@guavaq wrote:I understand if you want to have the least impact on your database then I would suggest that you stick with your current approach.
17MB in size is quite a small model. Considering even in the free version you get 1GB.
What you could also possibly do, is try and Append the data from staging table 2, back into Staging table 1? That could possibly save you some space, as well as data refreshing time.
Even though this solution solves this particular problem by avoiding having staging tables to delete, it does not answer the original question:
If, for whatever reason, you NEED to delete staging tables after they are being used (merged or appended), how do you do it?
Is there a way?
Thanks in advance!
Gabriel
Anybody has had the opportunity to find a solution to this?
I still can't figure out how to delete staging tables after being used and no longer needed.
Any assistance here will be greatly appreciated.
Thanks in advance,
Gabriel