I have several tables in my database with the names changed.

Using the Schema comparison, the suggested strategy is to DROP the table and create the new one empty, but this will generate a data loss.

How to "explain" to the Schema comparison tool that the old table name just changed for a new one and avoid data loss? What is the best approach to deal with renamed tables?