INFORMATION_SCHEMA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access programming.
I am trying to get the table and column attributes from an Access 97 DB
using Jet (via C#).
Is there a way to get this information... something like:
SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
since this information is in the design view, it would seem this is possible.
 
Back
Top