MySQL Forums
Forum List  »  MySQL Workbench

Re: create index in referenced tables in SQL Export
Posted by: Christian Dollfus
Date: July 15, 2014 02:11AM

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: create index in referenced tables in SQL Export
545
July 15, 2014 02:11AM


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.