I need to know the underlying table of a column in a view.  Using getschema("Columns") i can get a list of the columns in the view, but not the table that they come from.  Using getschema("ViewColumns") gives me the table that they come from but not if they are visible or not in the view... it includes all columns from all tables in the view regardless if they are visible in the view or not.

What I need is to get a list of columns in the view and the table that they belong to.  What's the best way to do this? Any advice?


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

comparison reporting -- technique suggestions?
.NET 2 DataTable SLOW
Best way to create a database
Addign a row to a dataset
Filtering Parent table on child records