Competition: What’s your favorite Redgate tool? Enter now.

Not breaking between

edited April 30, 2018 2:32PM in SQL Prompt
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


Sign In or Register to comment.