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

Add multiple columns not working

User, date Message
Written by fjuang
4 months ago
Category: General
3 posts since Tue, 24 Dec 13
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;
Written by ansgar
4 months ago
4784 posts since Fri, 07 Apr 06
Should be fixed in r4683
Written by fjuang
4 months ago
3 posts since Tue, 24 Dec 13
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.
Written by ansgar
4 months ago
4784 posts since Fri, 07 Apr 06
Yes, thanks for the hint. No need to be sorry - I oversaw that tiny detail again...
Written by ansgar
4 months ago
4784 posts since Fri, 07 Apr 06
Fixed in r4688
 

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