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' )
)
GOThe 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' )
)
GOIt would be nice to fix this!
Thanks!
Torsten
the following code is formatted like this:
CREATE TABLE test ( col1 int IDENTITY(1, 1) NOT NULL, col2 char(2000) NOT NULL DEFAULT ( 'A' ) ) GOThe 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' ) ) GOIt would be nice to fix this!
Thanks!
Torsten