When renaming a table, dependent objects are not renamed

ffoulksffoulks Posts: 2
edited July 2, 2009 10:55AM in SQL Refactor Previous Versions
When I use Smart Rename to rename a table, neither the foreign keys nor the defaults are renamed. Suppose I have two tables, Table1 and Table2, and that Table1 has a relation that refers to Table2. SQL Server names this relation:

FK_Table1_Table2

Then I change the name of Table1 to Table1Rev with Smart Rename. The name of the foreign key should now be

FK_Table1Rev_Table2.

However, the change script generated by Smart Rename does not change the name of the foreign key.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    I'm sorry to say that SQL Refactor is not designed to automatically rename constraints when the table name changes. We can consider this as a feature request for a future version if there is sufficient demand.

    Thanks!
Sign In or Register to comment.