-
Oct 28th, 2009, 04:44 AM
#1
Thread Starter
Frenzied Member
Retrieve MSAccess Table structure / column info
Hi DB Guru's
I have a problem, I'd like to know the column datatypes of some tables in an MS Access database. It's going to be a pain for me to get hold of the file and a copy of ms access to open it that way rather than a query. Does anyone know the query I can use to retrieve the information.
for example with an sqlite3 db i can do this "PRAGMA table_info(" + tablename + ");" and i'll get a resultset with like name, type and a few others, a row for each column of that table. I found examples for SQLServer but not MSAccess I assume it's still capable of it, just not commonly known.
-
Oct 28th, 2009, 05:14 AM
#2
Re: Retrieve MSAccess Table structure / column info
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|