DB independent? As in an entire list of tables in your MySQL server? Or as in independent from MySQL to say MS SQL Server? If the later then I'm sure each db as some form of query to get a list of tables, just look it up. I don't think there would be a unified way simple because each db is completly different (unless they all use the same "SHOW TABLES" command which I don't know if they do or not.) As far as the first way goes you could only do it, as far as I know, in some form of program. -Nick
p.s. this really isn't related to MySQL becuase you are asking about other db's but I thought I would be nice and answer it any how :) > hi all, > how do i retrieve a list of all tablenames in the database? i know i can > do it with a "show tables" query in MySQL, but i'd like to try to make > this db-independent.. > thanx! > jasper > > > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
