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

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



Answers

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • Options
    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 ...



  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.