Unexpected line wrapping

Refactors and formats SQL code.

Unexpected line wrapping

Postby snkscore » Thu Jan 27, 2011 4:26 pm

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?
Posts: 5
Joined: Mon Feb 25, 2008 3:48 pm

Postby james.billings » Mon Jan 31, 2011 1:12 pm

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Refactor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests