column names in table DDL bug

torsten.strauss

Hi Redgate Team,

SQL Prompt formats the following code 

CREATE TABLE dimension.date

(

ID_Date int NOT NULL

  , Date date NOT NULL

  , [Date] date NOT NULL

  , Day smallint NOT NULL

  , [Day] smallint NOT NULL

  , Test int NOT NULL

  )

CREATE TABLE dimension.date

(

ID_Date int NOT NULL

  , date date NOT NULL

  , date date NOT NULL

  , day smallint NOT NULL

  , day smallint NOT NULL

  , Test int NOT NULL

);

The problem here is that the column names Date and Day are converted to lowercase even they are surrounded by brackets, which is not correct.

Thanks for fixing!

squigley

Hello Torsten,

Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.

Can you confirm the version of SQL Server, SSMS, and SQL Prompt that you're using?

Also what active style are you using when this happens?

Thanks!

torsten.strauss

Hi!

SSMS 18.9.1
SQL Prompt Version 10.6.16.21150 

Thanks!

torsten.strauss

Settings

squigley

Hello Torsten,

Thanks for the update on your end.

So I made sure to have the same versions of both SSMS and SQL Prompt, and formatted the query using your same style and settings. Unfortunately, I still don't see the same issue.

Can you let me know what version of SQL Server that you're running this against just in case that plays a factor?

Thanks!