Smart rename bug: Unable to change casing of a field

DanAvni

If I have a field named GUID and I want to change it to Guid SQL Prompt Smart Rename says I am using the same name. My current workaround is to rename to GuidX and then remove the X and the script works fine. Please add support for changing letter casing.

Ben_P

Hi Dan, Thank you for your post. The latest release contains a fix for this issue, you can download it here:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.12.1701.exe

https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notes:

Fixes

• Fixed an issue where an unwanted space/tab was being added into the multi-part identifier in the WHERE clause.

• Fixed an issue where OPENXML statement wasn't recognized in Azure SQL Database.

• Fixed an issue that prevented exact match searches in SQL History.

Fixed an issue that prevented Smart Rename to rename column with same name but different case on case-sensitive database.