CREATE TABLE script - formating

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

CREATE TABLE script - formating

Postby jack-geronimo » Wed Jul 02, 2014 5:25 pm

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

Code: Select all
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
      ...
jack-geronimo
 
Posts: 1
Joined: Wed Jul 02, 2014 5:10 pm

Postby Aaron Law » Thu Jul 03, 2014 9:14 am

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 Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests