How can we help you today?

How can we help you today?

CREATE TABLE script - formating

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

CREATE TABLE dbo.User &#40;
      userId_pk BIGINT IDENTITY NOT NULL
    , userName NVARCHAR&#40;255&#41; NOT NULL
    , firstName NVARCHAR&#40;255&#41; NULL
    , lastName NVARCHAR&#40;255&#41; NULL
    , CONSTRAINT PK_User PRIMARY KEY &#40; userId_pk &#41;
 &#41;;

after formating:
CREATE TABLE dbo.User &#40;
      userId_pk BIGINT IDENTITY
                       NOT NULL
      ...

jack-geronimo July 02, 2014 12:25

0

Comments

1 comment

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.

Aaron L July 03, 2014 04:14

0

Add comment

Please sign in to leave a comment.