What are the challenges you face when working across database platforms? Take the survey
Options

column names in table DDL bug

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!

Answers

Sign In or Register to comment.