Not breaking between

torsten.strauss

Hi Redgate Team,

the following code is formatted like this:

CREATE TABLE test ( col1 int IDENTITY(1, 1) NOT NULL, col2 char(2000) NOT NULL
                                                          DEFAULT ( 'A' )
                  )
GO

The issue here and for a lot of other statements is that SQL Prompt will not consider that it makes not sense to break a logical statement between.
It only makes sense to break the entire logical fragment to sent it to a new line:

CREATE TABLE test ( col1 int IDENTITY(1, 1) NOT NULL
                                  , col2 char(2000) NOT NULL DEFAULT ( 'A' )
                  )
GO

It would be nice to fix this!

Thanks!

Torsten