The command "show tables;" will give you what you want. See: http://www.mysql.com/doc/en/SHOW.html
Gurhan On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote: > Hi, > > > I notice that lots of mysql gui's all can find out the contents (tables) > of any given database, how do they do this? > > Is it an sql command? > > I hope so, I need to know what the SQL command is so I can pass it to > perl DBI. > > M. > -- > Mark Worsdall > https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ > > --------------------------------------------------------------------- > 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