Refactors and formats SQL code.
Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson
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,
[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.
- Posts: 5
- Joined: Mon Feb 25, 2008 4:48 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: 1144
- Joined: Wed Jun 16, 2010 11:10 am
- Location: My desk.
Return to SQL Refactor 1
Who is online
Users browsing this forum: No registered users and 0 guests