Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2009

    Unanswered: Database's structure

    How does one find out, using sql commands, a database's tables, and columns names. I have a database that I would like to run reports on, but I do not know the names of tables, nor the column names in the tables. I tried show table with no result. This is a sql database. Thanks, gkenney.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Depends on how you're hitting the database. ADODB has a catalog collection that can provide this for you. If you're hitting the database directly in MSSQL, you can also avail yourself of the INFORMATION_SCHEMA objects, for which there is excellent documentation in BOL/MSDN.
    Last edited by Teddy; 12-04-09 at 14:43.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    what type of database is this
    virtually every SQL db has the capability to find the objects in its db. you 'just' need to know where to look

    in an Access/JET db its msysobjects
    in MySQL, and SQL Server (and no doubt Sybase) its information_schema
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2004
    Arizona, USA
    PostgreSQL also supports the information schema.
    Last edited by loquin; 01-04-10 at 12:34.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts