I do this with select db; show tables;
then parse through the result. Niclas Hedhman wrote: >On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote: > > >>Hi all, >>There is a way to know if I have table x in my db? >>Let's say some catalog tables that hold information about the db like >>tables name etc. >>and i can do query like "select tables from catalogName" and get all the >>tables in the db >> >> > >Talking about programmatically? >What client are you using? >Since the JDBC driver can pick up all the database, table and column >information, it should be available reasonably easy in other clients as well. > >--------------------------------------------------------------------- >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 > > > --------------------------------------------------------------------- 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
