How can we help you today? How can we help you today?

column names in table DDL bug

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!
torsten.strauss
0

Comments

4 comments

Sort by
  • 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!
    squigley
    0
  • torsten.strauss
    Hi!

    SSMS 18.9.1
    SQL Prompt Version 10.6.16.21150 

    Thanks!
    torsten.strauss
    0
  • torsten.strauss
    Settings
    torsten.strauss
    0
  • 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!
    squigley
    0

Add comment

Please sign in to leave a comment.