SQL Cannot add foreign key restraint

Asked Oct 01 '16 at 18:04

Active Oct 01 '16 at 18:04

Viewed 37 times

I have this code for SQL and continually get errors in trying to create the foreign key. I have no idea what I am doing.

CREATE TABLE IF NOT EXISTS `myDatabaseOne`.`Teams` (
    `idTeams` INT NOT NULL COMMENT '    ',
    `Semester` VARCHAR(45) NOT NULL,
    `Year` YEAR NOT NULL,
    `Captain` INT(5) NOT NULL,
    `Sport` INT NOT NULL,
    PRIMARY KEY (`idTeams`),
    INDEX `fk_Teams_Students_idx` (`Captain` ASC),
    INDEX `fk_Teams_Sports1_idx` (`Sport` ASC),
    CONSTRAINT `fk_Teams_Students`
      FOREIGN KEY (`Captain`)
      REFERENCES `myDatabaseOne`.`Students` (`idStudents`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    CONSTRAINT `fk_Teams_Sports1`
      FOREIGN KEY (`Sport`)
      REFERENCES `myDatabaseOne`.`Sports` (`idSports`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION)

asked Oct 01 '16 at 18:04

What errors do you constantly get? Please post the exact error message(s). – Philipp Oct 01 '16 at 18:05
Do they have the same data type? – mfredy Oct 01 '16 at 18:07
Do you need the apostrophe's? – mfredy Oct 01 '16 at 18:08
This should get you there [Link](http://chat.stackoverflow.com/transcript/message/33212987#33212987) – Drew Oct 01 '16 at 18:24
Do the keys in the other tables have indexes on them? Do these foreign keys already exist? – cnizzardini Oct 01 '16 at 18:33

SQL Cannot add foreign key restraint

0 Answers0