|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 7th, 2004, 03:01 AM
|
|||
|
|||
getting a list of foreign keys
Hi,
Im currently trying to generate my add screens in a ASP.NET application. To do so I would like to make selectboxes for the foreign keys. to do so I need a query(or any other sollution) to get a list with all the foreign keys for every table. There should be system tables to get this from, I just don't know where to select it from. Could any1 help me out here? Thank in advance, Timo
|
|
#2
October 7th, 2004, 03:09 AM
|
|||
|
|||
|
The systable with the foreign keys is sysforeignkeys. It only contains ID's with which i've got no idea what to do with.
any1 got any idea? cheers, Timo
|
|
#3
October 7th, 2004, 09:21 PM
|
|||
|
|||
|
Does nobody have the awnser to my question or does it sound vague? If you need more info, please don't hesitate to ask. I've been trying to find out where to get the foreign keys list from, but had no luck so far.
Thanks in advance, Timo p.s. Please excuse my english every once in a while. English is not my first language.
|
|
#4
October 13th, 2004, 02:32 AM
|
|||
|
|||
Sollution
If you find this and you have the same problem:
I got a reply with a working sollution in the sql section of this forum. cheers, Timo
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > getting a list of foreign keys |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
