database structure

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Hello,

Do you know how to obtain the structure (tables & fields) of an Access
database ? I'm using this following code from MSDN

DataTable schemaTable =
myConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null,
null, null, "TABLE"});

I have a field "Table_name" in my DataTable to have the name of the table,
but what can I do for fields ?

Thanks for your help

Steph
 
Steph:

Try walking through the Columns and the Rows. I don't remember the exact
structure off of the top of my head, but ColumnName and DataType will be in
there.
 
Back
Top