What are the challenges you face when working across database platforms? Take the survey
Options

ADD (column)

edited May 31, 2017 8:55AM in SQL Prompt
Hi Team,

The following statement is formatted this way:

-- Add seven additional bit columns (9)
ALTER TABLE dbo.FixedColumnBit
ADD
col3 bit NULL
, col4 bit NULL
, col5 bit NULL
, col6 bit NULL
, col7 bit NULL
, col8 bit NULL
, col9 bit NULL;
GO

I expect to see the first column (col3) aligned with col4 like:

ALTER TABLE dbo.FixedColumnBit
ADD
..col3 bit NULL
, col4 bit NULL
, col5 bit NULL
, col6 bit NULL
, col7 bit NULL
, col8 bit NULL
, col9 bit NULL;
GO

Thanks for fixing this!

Regards
Torsten
Friend of Redgate
Tagged:

Comments

  • Options
    FredericoJFredericoJ Posts: 34 Bronze 3
    edited June 1, 2017 10:26AM
    Hi @torsten.strauss

    Thanks for reporting this. We've managed to reproduce it locally and we've logged it in Jira (SP-6355).

    We don't yet have a timeline for investigating this, but we'll let you know as soon as we do.

    Best regards,

    Frederico
    Software Engineer
    Redgate Software
Sign In or Register to comment.