Results 1 to 2 of 2

Thread: Retrieve MSAccess Table structure / column info

  1. #1

    Thread Starter
    Frenzied Member Phill64's Avatar
    Join Date
    Jul 2005
    Location
    Queensland, Australia
    Posts
    1,201

    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.

  2. #2
    PowerPoster
    Join Date
    Nov 2002
    Location
    Manila
    Posts
    7,629

    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
  •  



Click Here to Expand Forum to Full Width