Unexpected line wrapping

snkscoresnkscore Posts: 8
edited January 31, 2011 8:12AM in SQL Refactor Previous Versions
When I use Layout SQL on a Create Table statement, all of the varchar columns have their "NULL" wrapped onto the next line.

For example this line:
[EventType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

Becomes this:
[EventType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS

The NULL is indented 26 spaces from where [EventType] is located.

The original line is 76 characters including all spaces. Even thought my "Line Wrap" value in SQL Refactor was set to 78, I tried changing it to 120 and then eventually I turned it off all together, but the NULLs continue to wrap.

Any idea?


  • Thanks for your post.

    If you haven't already, can you check to see if the problem persists if you use the latest cumulative patch? You'll find it here

    SQL Refactor has now been replaced with SQL Prompt 5 in case you didn't know - if your serial number has a valid support & upgrades add-on then you can use Prompt 5 for free.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.