You can see a list of the available storage types with SHOW ENGINES To see which engine is in use for any table you can SHOW TABLE STATUS or SHOW CREATE TABLE <tablename>
All of these commands, and more, are documented at : http://dev.mysql.com/doc/mysql/en/SHOW.html Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Scott Fletcher" <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> com> cc: Fax to: 06/28/2004 11:27 Subject: MySQL Storage Engines and Table Types..... AM Hi! How do I know which of the storage engine am I using or running, or whatever that use the databases/tables? Thanks, Scott F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
