Return
-
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”;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.