Spaces

torsten.strauss

Hi !

The following code is formatted with a lot of spaces between

ALTER TABLE mdm.Synchronization_Status
ADD
    CONSTRAINT PKCL_Synchronization_Status_synchronization_timestamp PRIMARY KEY
        ( synchronization_timestamp )                                 WITH ( FILLFACTOR = 100 ) ON [DEFAULT];
GO

same here

ALTER TABLE mdm.Synchronization_Status
ADD
    CONSTRAINT CHK_Synchronization_Status_status CHECK ( status IN ('R', 'S'
                                                                   , 'F'
                                                                   )
                                                       );
GO

My stylsheet is available https://forum.red-gate.com/discussion/84483/case#latest here.

Thanks!
Torsten

Jessica R

Hi @torsten.strauss !

It looks like this is mainly due to the wrapping option in your Style settings. 

Global>Whitespace>Wrapping>"Wrap lines longer than"

Can you kindly try increasing the value of this, or disabling it?

 

torsten.strauss

This will lead to something like this:

EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Table to save the MDS synchronization status', @level0type = N'SCHEMA', @level0name = N'mdm', @level1type = N'TABLE', @level1name = N'Synchronization_Status';
GO

ALTER TABLE mdm.Synchronization_Status
ADD CONSTRAINT CHK_Synchronization_Status_status CHECK ( status IN
    (
        'R', 'S', 'F'
    )
                                                       );
GO

Which even looks worse comparing to the first issue ...

Jessica R

Hi @torsten.strauss!

Enabling Statements> Schema(DDL) > Place constraints on new lines should get them on individual lines- could you kindly give this a try?