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

Data type not lower case

Hi Redgate Team
the data types are not converted to lower case anymore.

Thanks for fixing!


CREATE TABLE test
(
id INTEGER IDENTITY(1, 1) NOT NULL
  , filler CHAR(1000) NOT NULL
DEFAULT ('A')
);
GO

Version 10.6.16.21150 
latest SSMS Version.


Answers

  • Options
    Dan_JDan_J Posts: 454 Silver 2
    Hi @torsten.strauss

    Thanks for reaching out to us on this. And thank you for providing your Style file!

    I have been able to replicate the issue you are seeing here, it appears to be being caused by the use of &nbsp. As soon as I removed it from the code SQL Prompt applied the correct formatting.

    I am just reaching out to our development team for their input on this, I will update you as soon as I can on this.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Options
    Dan_JDan_J Posts: 454 Silver 2
    Hi @torsten.strauss

    I have now heard back from our development team on this.

    Unfortunately, given that the functionality around lower casing data types is still working (it just isn't in your example because of the use of &nbsp), and our development teams' existing workload, they are unable to look into this further at this stage.

    Please don't hesitate in coming back to us if you're like to discuss this any further.


    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Options
    Will this issue be put on the bug list for future correction?
Sign In or Register to comment.