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:


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


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


  • Brian DonahueBrian Donahue Posts: 6,590 New member

    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.

Sign In or Register to comment.