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

Spaces

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


Thanks!
Torsten



torsten.strauss
0

Comments

3 comments

Sort by
  • 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?

     

    Jessica R
    0
  • 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 ...



    torsten.strauss
    0
  • Jessica R
    Hi @....strauss!

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

Add comment

Please sign in to leave a comment.