You’re going to run into situations where someone has made poor choices in naming objects, or maybe the business logic has changed and the object name no longer makes sense. Either way, easily and quickly taking care of renaming the objects within scripts can be a pain.
Let’s take this code as an example:
The table variable
@a is a poor choice, so I want to replace it. Yes, I can do a search and replace to try to find it and replace it within the code, but SQL Prompt offers an alternative that is both easier and, depending on if you want to review the code as you change it, faster.
I can highlight any use of the variable
@a and press the function key F2. This then highlights every use of that variable:
If I start typing, I can rename the object, quickly and easily, and it renames everywhere at the same time:
If I hit the Enter key, that gets committed to the code. However, if I hit the escape key, ESC, the changes are removed from script and it reverts back to what it was originally.
That’s it – a quick tip to help you make your code cleaner and more readable in a couple of clicks with SQL Prompt.
Take a look at my video below, or browse the rest of the handy #SuperSQLTips videos from other Data Platform MVPs and SQL Server experts, helping you get the most out of SQL Prompt:
If you’re new to SQL Prompt check it out for yourself with a free 28-day trial and see how much more productive you can be writing code every day.
Like this? Share it with other SQL professionals using the social sharing buttons below – and don’t forget to give me a shoutout @GFritchey. Thanks for reading.
Also in Blog
In this post, I’d like to introduce you to the Universal Architecture idea described by J.B. Rainsberger in the podcast Unit Testability and the Universal Architecture.
Everyone wants to deliver...
Also in Redgate products
In this article, I'll be showing you how to automatically compare the schema of two versions of the same database, and then subsequently deploy to the target database any differences detected in the s...
Also about SQL Prompt
When you’re hard at work, it’s all too easy to make a mistake as you rush to get a job done. Say, for example, you have a QA database you need to get rid of. You run a query to drop it and then…...