Given...
/*Specifying Storage Options for an Index Associated with a Constraint*/
CREATE TABLE B
(b1 INT PRIMARY KEY)
ENABLE PRIMARY KEY USING INDEX TABLESPACE users;
/*Specifying the Index Associated with a Constraint*/
CREATE TABLE a
(a1 INT PRIMARY KEY USING INDEX
(CREATE INDEX ai ON a (a1)));
When I create these tables with the USING INDEX clause and drag and drop these tables into a model, then create the scripts, the result scripts are as follows:
CREATE TABLE "JLIN"."B"(
"B1" Integer
)
/
ALTER TABLE "JLIN"."B" ADD CONSTRAINT "SYS_C0066436" PRIMARY KEY ("B1")
/
CREATE TABLE "JLIN"."A"(
"A1" Integer
)
/
CREATE INDEX "JLIN"."AI" ON "JLIN"."A" ("A1")
/
ALTER TABLE "JLIN"."A" ADD CONSTRAINT "SYS_C0066435" PRIMARY KEY ("A1")
USING INDEX "JLIN"."AI"
/
The scripts do not follow from the original.
WORKAROUND: Define a unique index on the Indexes tab of the Entity dialog. Then select an existing index on the Key Properties dialog, General tab, when setting the "Name of Using Index."
STATUS: Waiting of fix in a future release of Toad for Data Modeler
