I would like to rename a field in a table, but I know that it is used in multiple databases. Can I use Smart Rename to do that?
Comments
3 comments
-
Hi @Carla
Thanks for your post.
There is information on renaming in SQL Prompt in the links below.
https://documentation.red-gate.com/sp9/refactoring-your-code/renaming-scripted-objects
https://documentation.red-gate.com/sp9/refactoring-your-code/renaming-objects
I hope this helps.
Richard. -
I have multiple databases on one server. I want to rename a table in one of the databases, but it is also used in one or more of the other databases. I would like to know if Smart Rename will pick up the instances where the table name is used in the other databases, like Search does.
-
Hi @Carla!
Smart Rename currently can't rename across databases, I'm sorry to say. Could you please vote on the feature request for this here: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1742941-external-database-dependencies?
Thank you!
Add comment
Please sign in to leave a comment.