Re: create index in referenced tables in SQL Export
Yes i checked that. THis is the SQL Code generated by the Workbench for the referenced table T_CAV:
DROP TABLE IF EXISTS `REGMARKET`.`T_CAV` ;
CREATE TABLE IF NOT EXISTS `REGMARKET`.`T_CAV` (
`idT_CAV` BIGINT NOT NULL,
`EDI_CodepflegeCode` INT NULL,
`EDI_MerkmalCode` INT NULL,
`EDI_Merkmalswert` VARCHAR(45) NULL,
PRIMARY KEY (`idT_CAV`),
CONSTRAINT `fk_T_CAV_T_Vertrag1`
FOREIGN KEY (`idT_CAV`)
REFERENCES `REGMARKET`.`T_Vertrag` (`BetragKonzessionsabgabeMerkmalswert`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_T_CAV_T_Vertrag2`
FOREIGN KEY (`idT_CAV`)
REFERENCES `REGMARKET`.`T_Vertrag` (`TemperaturabhängigeLieferstelleMerkmalswert`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_T_CAV_T_Vertrag3`
FOREIGN KEY (`idT_CAV`)
REFERENCES `REGMARKET`.`T_Vertrag` (`ProfilscharMerkmalswert`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_T_CAV_T_Vertrag4`
FOREIGN KEY (`idT_CAV`)
REFERENCES `REGMARKET`.`T_Vertrag` (`TarifanzahlMerkmalswert`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
There is no index definition. I guess that is the problem. This code is generated ba the Workbench. Does I need to select something else ?
Subject
Views
Written By
Posted
1110
July 06, 2014 07:25AM
491
July 07, 2014 12:54AM
510
July 14, 2014 10:34PM
615
July 15, 2014 01:39AM
Re: create index in referenced tables in SQL Export
545
July 15, 2014 02:11AM
533
July 24, 2014 12:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.