Maybe this is too much of a noob question but bear with me.
I'm assuming that I have a choice between
CREATE TABLE (..) REFERENCES other
and
CREATE TABLE (..) FOREIGN KEY () REFERENCES other
What is the differences between the two and why/when would I choose one over the
other?
