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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tranforming the format of XML 4
SQL Server SP equivalent 5
Detailsview - how do I add the first record? 1
GetOleDbSchemaTable(OleDbSchemaGuid.Columns,... 11
How to get columns from a schema.table? 3
CREATE TABLE: how to define a field's DEFAULT data value? 4
How to identify Auto Increment fient in Access database 2
Get table, column description metadata 2

Back
Top