How can we help you today? How can we help you today?

table rename means a drop table and recreate?

Hi,

I am in the process of evaluating SQL source and I have renamed a table & then went to commit the change. I noticed that SQL source wants to drop the table and the create the table with the new name. Is this how this software handles a rename?

Thanks
M
5QL53rv3r
0

Comments

3 comments

Sort by
  • David Atkinson
    Yes, for the time being, a rename isn't treated in any special way so it is seen as a drop and the creation of a new object. Is there any reason why this would cause a problem for you?

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • 5QL53rv3r
    will data be lost from the tables or is the data copied to temp tables and then inserted into the renamed table. so it looks like sp_rename isn't used.
    5QL53rv3r
    0
  • David Atkinson
    Yes, if you get latest, data will be lost as we don't know that the rename has occurred. This would be a good reason to save the 'intent' of the change alongside it, and use a smart rename rather than a drop/create.

    Thanks for bringing this to our attention. In the meantime, instead of using get latest for this change, you'll have to make a manual change locally with your won rename script (you can try using SQL Refactor's smart rename).

    David
    David Atkinson
    0

Add comment

Please sign in to leave a comment.