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

Inappropriate formatting on columns which start with DayOfWeek...

When formatting the following table, the Of in all columns which start with DayOfWeek or DayOfMonth are set to lower case.  I am sure this is because we have Keyword Casing set to lowerCamelCase but I would not expect this to occur as the keywords are only part of the larger word.  I know that I can add tags to ignore formatting but it shouldn't be necessary.

create table dm.DimDate
    (
        DimDateID int not null
       ,DayOfWeekLongName varchar(10) not null
       ,DayOfWeekShortName varchar(3) not null
       ,DayOfCalendarYear int not null
       ,DayOfFiscalYear int not null
    );
go
Aaron Cool
0

Comments

1 comment

Sort by
  • Jon_Kirkwood

    Hi @...

     

    Thank you for reaching out on the Redgate forums and sorry you are getting this formatting issue.
    I agree that it doesn't seem like casing options should be applying to an object name like you are outlining.

     

    I've tried changing some settings through my formatting style and am not getting the same results as you. 

    Are you able to share your style from C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10\Styles so we can try and replicate further.

     

    You can upload via this secure file link - https://files.red-gate.com/requests/ZR8R3cmA8B2n29PZoLuQsB

    The link will be valid for 2 weeks

    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.