table metadatA_?

[Emre DÝNÇER]

Is there a possibility for me to retrieve table metadata so that i can catch
a column of a table is foreign key at runtime?

best regards
emre dincer

 

[Nicholas Paldino [.NET/C# MVP]]

Emre,

Yes, there is. You have to look at the information schema views to
figure out this information:

http://msdn2.microsoft.com/en-us/library/ms186778.aspx

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

DataTable has methods/properties that give you that info. Take a look at
the DataRelation class and to DataTable.ChildRelations and
DataTAble.ParentRelations