Welcome to the Treehouse Community
Looking to learn something new?
REFERENCES and foreign keys syntax.
I've been using MySQL Workbench and I'm unsure if I'm doing the foreign key section correctly. Is the syntax the same? I'm asking because it seems to accept "REFERENCES" as a statement and I don't get any errors, but it doesn't really do anything. As far as I can tell, it isn't actually creating a foreign key.
Maybe there's an additional step I'm missing? I've seen some videos where people actually add "FOREIGN KEY" at the bottom of the block.
Steven Parker216,057 Points
A complete specification usually uses both the terms FOREIGN KEY and REFERENCES on the definition line.
To allow us to give you more specific hints, please show your complete query syntax here.