6 Replies - 5191 Views - Last Post: 07 November 2001 - 11:55 AM Rate Topic: -----

#1 objekt404  Icon User is offline

  • Whiskey Tango Foxtrot!?

Reputation: 0
  • View blog
  • Posts: 1,568
  • Joined: 15-April 01

SQL:get.Tables?

Posted 01 November 2001 - 04:41 AM

i'm stuck.  does anyone out there know how to retrieve a list of tables inside an .mdb through sql?
Is This A Good Question/Topic? 0
  • +

Replies To: SQL:get.Tables?

#2 objekt404  Icon User is offline

  • Whiskey Tango Foxtrot!?

Reputation: 0
  • View blog
  • Posts: 1,568
  • Joined: 15-April 01

Re: SQL:get.Tables?

Posted 01 November 2001 - 07:28 AM

possible solution to this problem (please, allow me to suck some more space here...):

each of the .mdbs will have a ToC-table.  simple, neh?  took 3 pots of coffee & 'bout an hour of random conversation w/my uncle to spur that one!

...though if anyone *does* know how to retrieve a table list from a DB i'd still be interested in seein' it

Was This Post Helpful? 0
  • +
  • -

#3 The Neoracle  Icon User is offline

  • Check, check, 1, 2.
  • member icon

Reputation: 21
  • View blog
  • Posts: 4,097
  • Joined: 30-March 01

Re: SQL:get.Tables?

Posted 01 November 2001 - 01:17 PM

You just want a list of the tables in a database?  That's simple (in MySql).  Use the SHOW TABLES FROM db_name statement.  I don't know if you are using MySql or something else, and if that something else has that function, but MySql does and that's all I've got experience on.  Plus, why would you need anything else? ;)  
Was This Post Helpful? 0
  • +
  • -

#4 objekt404  Icon User is offline

  • Whiskey Tango Foxtrot!?

Reputation: 0
  • View blog
  • Posts: 1,568
  • Joined: 15-April 01

Re: SQL:get.Tables?

Posted 01 November 2001 - 02:06 PM

that sounds like the ticket, but all i got is access :(
i *wish* i knew where to get some better software, but i really haven't had the time or bandwidth.
thanks for the pointer though, i'll definitely have to learn more about *other* DBs than plain access ('specially if i plan to make money at this ;)
Was This Post Helpful? 0
  • +
  • -

#5 IceStorm  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 15
  • Joined: 16-May 01

Re: SQL:get.Tables?

Posted 07 November 2001 - 07:59 AM

Take a look at the following URL:

http://www.asp101.co...=db%5Fdsn%2Easp

It explains exactly how to do this.

Was This Post Helpful? 0
  • +
  • -

#6 The Neoracle  Icon User is offline

  • Check, check, 1, 2.
  • member icon

Reputation: 21
  • View blog
  • Posts: 4,097
  • Joined: 30-March 01

Re: SQL:get.Tables?

Posted 07 November 2001 - 11:47 AM

**Cough** http://www.mysql.com/ **cough**  It's FREE!
Was This Post Helpful? 0
  • +
  • -

#7 objekt404  Icon User is offline

  • Whiskey Tango Foxtrot!?

Reputation: 0
  • View blog
  • Posts: 1,568
  • Joined: 15-April 01

Re: SQL:get.Tables?

Posted 07 November 2001 - 11:55 AM

Quote

Quote: from The Neoracle on 1:47 pm on Nov. 7, 2001
**Cough** http://www.mysql.com/ **cough**  It's FREE!

yes, but i'm not hosting it myself.  i dunno what their running, but i'll ask 'em 'bout mySql

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1