Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael71
Posting Yak Master
126 Posts |
 Posted - 2006-12-25 : 02:39:22
|
| What is a Primary Key and Foriegn Key and how do they relate? Also, if I have 18 tables...how do I know the tables relate to another. Thanks. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-12-25 : 02:51:17
|
| This is very basic question, why dont you google it you will get loads of information on it. Also you can check out on Book online(SQL Server help file) for this, they have given a better explaination on it.Chiraghttp://chirikworld.blogspot.com/ |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-25 : 03:26:11
|
| One question will lead to another and another....its best you get a book to grasp a clearer picture or go for some training.For books see herehttp://www.sqlteam.com/store.aspor like Chirag said, read Books Online. press the F1 key in MS SQLAfrika |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-25 : 03:26:24
|
| Simplest way to see the relationships between the tables is to create table diagrams in Enterprise manager.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-25 : 04:20:58
|
| http://sqlteam.com/forums/topic.asp?TOPIC_ID=72957MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Primary Key and Foriegn Key?