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
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Emre DÝNÇER" <ed*****@meteksan.com.trwrote in message
news:uO**************@TK2MSFTNGP06.phx.gbl...

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

[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

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
"Emre DÝNÇER" <ed*****@meteksan.com.trwrote in message
news:uO**************@TK2MSFTNGP06.phx.gbl...

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