I’m working with an MS SQL Database where the object ‘Target’ is extensively used. It appears in various forms such as a field name (Target), a variable (@Target), and within several table-valued functions.

Traditionally, to replace such an object, I’ve used SQL Server Management Studio (SSMS) to generate scripts for the affected database objects, then manually edited these scripts to make the replacements, and finally created a new database using the modified scripts. This method, although effective, can be quite laborious.

I’m seeking a more streamlined approach. Is there a way to directly search for and replace references to the ‘Target’ object across the entire database without having to first generate and manually edit the scripts? Ideally, I’m looking for a solution that can be implemented directly within the existing database.