Can Smart Rename rename across multiple databases?

Carla

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?

RichardL

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. 

Carla

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.

Jessica R

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!