distal-attribute
distal-attribute
distal-attribute
distal-attribute

Add multiple columns not working

fjuang posted 12 months ago in General
Adding multiple columns to table on mssql is generating

ALTER TABLE "dbo"."Wins_process_run_cache1"
ADD "Column 6" VARCHAR(8000) NULL,
ADD "Column 7" VARCHAR(8000) NULL,
ADD "Column 8" VARCHAR(8000) NULL;

can you make it generate this or tell me if there's a compatibility setting to make it generate properly?

ALTER TABLE "dbo"."Wins_process_run_cache1"
ADD "Column 6" VARCHAR(8000) NULL,
"Column 7" VARCHAR(8000) NULL,
"Column 8" VARCHAR(8000) NULL;
ansgar posted 12 months ago
Should be fixed in r4683
fjuang posted 12 months ago
Its fixed but while testing this, I noticed that drop has the same issue as add. Its generating this

ALTER TABLE "dbo"."aaa"
DROP COLUMN "Column 8",
DROP COLUMN "Column 9",
DROP COLUMN "Column 10";

needs to be

ALTER TABLE "dbo"."aaa"
DROP COLUMN "Column 21",
COLUMN "Column 12",
COLUMN "Column 13",
COLUMN "Column 14";

Sorry to be repetitive.
ansgar posted 12 months ago
Yes, thanks for the hint. No need to be sorry - I oversaw that tiny detail again...
ansgar posted 12 months ago
Fixed in r4688

Please login to leave a reply, or register at first.