emehrkay Posted February 26, 2007 Share Posted February 26, 2007 ?? thanks Link to comment https://forums.phpfreaks.com/topic/40271-what-query-do-i-run-to-return-all-of-the-table-names-in-a-db/ Share on other sites More sharing options...
JBS103 Posted February 26, 2007 Share Posted February 26, 2007 $query = "Show tables"; Should work I believe. More info here: http://dev.mysql.com/doc/refman/5.0/en/show.html Link to comment https://forums.phpfreaks.com/topic/40271-what-query-do-i-run-to-return-all-of-the-table-names-in-a-db/#findComment-194816 Share on other sites More sharing options...
fert Posted February 26, 2007 Share Posted February 26, 2007 http://us2.php.net/manual/en/function.mysql-list-tables.php Link to comment https://forums.phpfreaks.com/topic/40271-what-query-do-i-run-to-return-all-of-the-table-names-in-a-db/#findComment-194818 Share on other sites More sharing options...
radi8 Posted February 27, 2007 Share Posted February 27, 2007 $sql = "SHOW TABLES"; it's case sensitive Link to comment https://forums.phpfreaks.com/topic/40271-what-query-do-i-run-to-return-all-of-the-table-names-in-a-db/#findComment-194869 Share on other sites More sharing options...
magic2goodil Posted February 27, 2007 Share Posted February 27, 2007 last i checked sql was no case sensitive on it's built in commands. Link to comment https://forums.phpfreaks.com/topic/40271-what-query-do-i-run-to-return-all-of-the-table-names-in-a-db/#findComment-194957 Share on other sites More sharing options...
emehrkay Posted February 27, 2007 Author Share Posted February 27, 2007 thanks Link to comment https://forums.phpfreaks.com/topic/40271-what-query-do-i-run-to-return-all-of-the-table-names-in-a-db/#findComment-195224 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.