SQL Complete Formatter aligns identifier case regardless what is defined in database
Hi, I have come across situation where SQL Complete code formatter will align column name case to be identical when the column names are identical, even though in actual database the column name might be different. For example, if I have the following:
- SELECT product_name FROM db.dbo.table
- UNION
- SELECT PRODUCT_NAME FROM db_other.dbo.other_table
And I run SQL Complete formatter (format selection/document shortcut) it will become as follows:
- SELECT product_name FROM db.dbo.table
- UNION
- SELECT product_name FROM db_other.dbo.other_table
even though the column name from db_other.dbo.other_table should be capitalized since that's how it is defined in the database. In my Options-->Formatting-->Profiles-->Text Case-->Indentifier Case--> As in the database is selected;
Is there some way/setting that preservers column names as they are defined in the database when formatter is run?
Version: 6.15.5
SSMS: 19.0.20209