Refactors and formats SQL code.
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.
- Posts: 1
- Joined: Thu Jul 02, 2009 1:57 pm
- Location: Indiana University School of Medicine
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.
- Posts: 6590
- Joined: Mon Aug 23, 2004 9:48 am
Return to SQL Refactor Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests