Querystring Datatable Schema to Get Foreign Key Constraint

[Jason Butera]

I have a datatable in a dataset that contains columns that are Foreign
Keys to other tables that are not returned in the dataset. Is there a
way I can query a column of a datatable and know that the entry is a
Foreign Key (a primary key in another table). If so, can I get that
other table's name?

Thanks,

Jason

 

[Roy Osherove]

I have a datatable in a dataset that contains columns that are Foreign
Keys to other tables that are not returned in the dataset. Is there a
way I can query a column of a datatable and know that the entry is a
Foreign Key (a primary key in another table). If so, can I get that
other table's name?

Thanks,

Jason

I've written a schemaHelper class that does exactly that:
it will bring back a dataset with tables *and* relations between them
automatically. check it out:
http://weblogs.asp.net/rosherove/story/9661.aspx