CREATE TABLE script - formating

jack-geronimo

Why SQL Prompt 6 breaks the line after the IDENTITY key word in an create statement e.g.:

CREATE TABLE dbo.User (
      userId_pk BIGINT IDENTITY NOT NULL
    , userName NVARCHAR(255) NOT NULL
    , firstName NVARCHAR(255) NULL
    , lastName NVARCHAR(255) NULL
    , CONSTRAINT PK_User PRIMARY KEY ( userId_pk )
 );

after formating:
CREATE TABLE dbo.User (
      userId_pk BIGINT IDENTITY
                       NOT NULL
      ...

Aaron L

Hi Jack,

I don't think there's a way to change this in Prompt at the moment, it looks like it's always been that way (I just gave it a go in Prompt 5). Fortunately we are currently collecting changes we want to make to the formatting engine and this is the kind of thing we're looking for, you can suggest this and any other changes you'd like to see on our survey.

Thanks,
Aaron.