SHOW CREATE TABLE tablename; or SHOW TABLE STATUS LIKE 'tablename'; gives you what you want...
See: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Gurhan -----Original Message----- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: table type airline? >From my sql How can I see what the types of tables I have are.. i.e. how do I verify if a table is an ISAM, HEAP, InnoDB... Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." **************************************************************** Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you ***************************************************************** --------------------------------------------------------------------- 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
