When renaming a table, dependent objects are not renamed

[ffoulks]

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.

[Brian Donahue]

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!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521