ADD (column)

torsten.strauss

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

FredericoJ

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