Options
Unexpected line wrapping
snkscore
Posts: 8
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
NULL,
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?
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
NULL,
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?
Comments
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.
Redgate Software