Given a table (for example EMPLOYEES) with a primary key (EMP_ID_PK), Toad 8.6 displays the script in the Schema Browser | Script tab in an alter statement with the primary key having all of the storage information and the index was secondary.
For example...
ALTER TABLE EMPLOYEES ADD (
CONSTRAINT EMP_ID_PK
PRIMARY KEY
(EMPLOYEE_ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
In Toad 11.6.1 and Toad 12, it is now scripted as follows...
ALTER TABLE "EMPLOYEES2" ADD (
CONSTRAINT "EMP_EMP_ID_2_PK"
PRIMARY KEY
("EMPLOYEE_ID")
USING INDEX "EMP_EMP_ID_2_PK"
ENABLE VALIDATE);
None of the options in "View\Edit Script Options" can cause Toad 12 to display as it does in Toad 8.6. Is it possible to have the scripts displayed as Toad 8.6?