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.