Page 1 of 1

Foreign Key Question

Posted: Thu Apr 28, 2005 10:43 pm
by Texan
A quick question, I would like to do some finishing touches on my
database. I would like to set up all of my freign keys in my DB.
How do I set these up? I know I should know, but I don't. Are
there any benefits do setting them up?

Thanks

Posted: Fri Apr 29, 2005 2:19 am
by Chris Corbyn
Dude.... if your database is finshed I can't see how you don't have these set up if you need them. It's the almost the first thing you should do.

I guess it's time to read up on database design and Normalization.

Google: "Database normalization"

Posted: Fri Apr 29, 2005 4:29 am
by Texan
The project isn't done, I am just doing some test scrips and such to make sure the db
is setup in the best possible way.