Is there a way to look for all of the foreign keys in a data set?
I know there's a way to look for all of the relations:
new DataSet().Relations
Is there a similar proptery for just foreign keys?
Asked
Active
Viewed 4,383 times
2
-
If a relation is not a foreign key, then what is it? – Mohammad Dehghan Feb 13 '12 at 14:50
-
@MD.Unicorn: It looks like you can make a `foreign key` without it being a `relation`. – poy Feb 13 '12 at 16:06
1 Answers
2
There is a foreignkeyconstraint Class, so for each DataTable in your dataset you can find the list of its Constraints, which will give you all constraints including any foreign keys of type foreignkeyconstraint.
Mahmoud Gamal
- 78,257
- 17
- 139
- 164