column names in table DDL bug

torsten.strausstorsten.strauss Posts: 271 Silver 3
edited June 21, 2021 10:46AM in SQL Prompt
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!
Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.