Settings and activity
2 results found
-
302 votes
SQL Prompt for Azure Data Studio is now in public preview!
The aim of this public preview is to learn from the ADS community about how SQL Prompt can enhance your developer experience, adding improvements and new features based on your feedback.
With SQL Prompt, you can use an extensive collection of code snippets to write your SQL code quickly and efficiently. You can also keep your code consistent using the powerful formatting capability, with the ability to customise the applied style to suit your preferences.
We’d love to hear your feedback. You can get in touch with the team either via the new SQL Prompt in ADS forum: https://forum.red-gate.com/categories/sql-prompt-in-ads or email us at sqlprompt.in.ads@red-gate.com.
Get started with SQL Prompt for Azure Data Studio now. Download it here: https://download.red-gate.com/EAP/SQLPromptADS.zip
Daniel Lancelot
supported this idea
·
-
58 votes
We’re going to be reviewing this over the next couple of months, which would be released via the SQL Prompt for Teams EAP (get in touch if you want to know more).
In the meantime please add any other information that you think would be useful.
An error occurred while saving the comment Daniel Lancelot
supported this idea
·
Real shame there has been no progress on this even after over 6 years...
Not functionality that is required often - but generally speaking, when renaming columns, I suspect that the most common use case is to update legacy db's to confirm with a consistent naming strategy - and in most cases this will involve renaming multiple columns within the same tables. For this use case, bulk renaming is essential.
I have just been tasked by a client to perform this task on a legacy db - and I have identified 51 tables with 770 dependant entities that require updating. Most of these tables have between 5 and 20 fields. Using the Smart Rename tool to do this would require somewhere in the region of ~8,000 separate scripts to be generated... which is obviously completely nonsensical.
I believe that for the majority of the alterations I will be quicker to script them manually, as the benefits of being able to update 10 fields in a single stored proc in one go outweigh much of the automation gains for those tables which have a low number of dependencies.