[cfaussie] Re: OT: another mysql question

[Steve Soars]

you might try   mysql_list_tables()   from the mySQL docs @ http://www.mysql.com/doc/en/mysql_list_tables.html ----- Original Message ----- From: Daniel Morphett To: CFAussie Mailing List Sent: Friday, March 28, 2003 11:38 AM Subject: [cfaussie] OT: another mysql question Got another mysql question for you Apart from the show tables command, or show tables like '%blah%', or describe <tablename>, are there any other queries you can use to simulate the select name from sysobjects where type = 'u' query in sql server? basically I'd like to query the system tables directly, and to be able to control (via aliasing) the headings of each column. Can't alias the output of show tables, as far as I know. Thanks Daniel Morphett Web Developer, DBA www.daemon.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/