| Author |
Topic |
|
jeusdi
Starting Member
27 Posts |
 Posted - 2005-03-31 : 07:02:11
|
| I suppose that SQL-Server supports foreign keys, no? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-03-31 : 07:42:37
|
| Yup in principle......see CONSTRAINTS i BOL (or here)There may be some shortcomings for you in the area of CASCADE update/deletes |
 |
|
|
jeusdi
Starting Member
27 Posts |
Posted - 2005-03-31 : 07:56:56
|
| EEEHHHH???? I only want to know if I can create a foreign key of a table to other table. Yes or no?Thanks. |
|
|
|
ijprasad
Starting Member
29 Posts |
Posted - 2005-03-31 : 08:06:02
|
| Yes, you canInderjeet |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-31 : 13:16:09
|
| What sort of question is this ?Don't ALL major 'relational' database vendors support FOREIGN KEYS ?!rockmoose |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-03-31 : 15:27:03
|
| My understanding is that MySql supports the systax but not the enforcement of DRI. We can debate whether MySql is a major relational database vendor, or if its even a relational database.HTH=================================================================In order to improve the mind, we ought less to learn than to contemplate.-Rene Descartes, philosopher and mathematician (1596-1650) |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-03-31 : 15:40:41
|
| ah, but did you hear the latest on mySQL ?http://news.zdnet.co.uk/software/applications/0,39020384,39192964,00.htmWe'll see I guess ... I'm pretty skeptical ...- Jeff |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-04-01 : 04:19:05
|
| "EEEHHHH????....Nothing".My answer was concise and accurate (except for the spelling of the word IN)Please take some time to do some research yourself on the topic before asking others to do the work for you. A learning habit/mindset will be more beneficial to you in the long run, than one which expects others to do the work for you. This is a free-site staffed by volunteers...don't complain in the absence of a justifiable reason. A more reasonable (non-contentious) response (or a more detailed original question!!) would be useful. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-04-01 : 18:22:46
|
| Consider the source, Andrew. You mentioned BOL which really should have been enough for anyone with even a modicum of initiative.HTH=================================================================In order to improve the mind, we ought less to learn than to contemplate.-Rene Descartes, philosopher and mathematician (1596-1650) |
|
|
|
|
foreign keys