Is there a way to generate an alter table script adding column to middle of a table? (4321935)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Is there a way to generate an alter table script adding column to middle of a table?
Description

When trying to alter a table by adding a column in the middle of a table, instead of adding a column at the end, the alter script drops the table and it recreates the table again with the new column in the middle of a table.

Does Toad Data Modeler have a feature of generating an alter script by adding a column in the middle of a table, without having to drop the table? So, if a column is added in the middle of a table, the alter script should generate something like this...
ALTER TABLE “Test_Table” ADD COLUMN “is_reject” TINYINT(1) UNSIGNED DEFAULT 0 NOT NULL AFTER “cleared_by”;
Cause

Toad Data Modeler cannot do an alter script like this at this time. By default, Toad Data Modeler uses temporary tables when generating a Drop and Create statement for change scripts. So, no data is lost. Temporary Table option is set by default in Change Script Wizard.

Example use temporary table:
CREATE TABLE `Entity1_1058177698AF438F9B83E756AD243D40`
(
`Attribute1` Char(20),
`Attribute3` Char(20),
`Attribute2` Char(20)
)
;
INSERT INTO `Entity1_1058177698AF438F9B83E756AD243D40` (`Attribute1`, `Attribute2`) SELECT `Attribute1`, `Attribute2` FROM `Entity1`
;
DROP TABLE `Entity1`
;
ALTER TABLE `Entity1_1058177698AF438F9B83E756AD243D40` RENAME TO `Entity1`
;
Resolution

WORKAROUND:
None

STATUS:
Waiting for this enhancement to be implemented in a future release of Toad Data Modeler.
Defect ID

TDM-4680

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Is there a way to generate an alter table script adding column to middle of a table? (4321935)

Title

Description

Cause

Resolution

Defect ID

Leave a Comment