ADD (column)
torsten.strauss
Posts: 271 Silver 3
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
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
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
Redgate Software