On 11/25/2015 3:43 PM, H?ctor Fiandor wrote: > I have asked previously about this matter but nobody answer me. > > I have a table to be copied in another one with other name as a temp. > > Then I drop the first one. > > Then I create another one with same as the dropped table. > > Then I copy from the temp to the new created. > > > > I do all this but in three phases I may answer is It is possible to do this > in one phase?
I can do it in zero phases. As far as I can tell from your description, the sequence leaves the database in the exact same state it started from. So you may as well do nothing at all and achieve the same result. -- Igor Tandetnik
