This is of course MySQL 5 SELECT engine FROM information_schema.tables WHERE table_schema='...' AND table_name='...';
I haven't used MySQL 4 Maybe this might help SHOW CREATE TABLE <tbl-name>; You should see TYPE=MyISAM or TYPE=BDB or some other engine in the string ----- Original Message ----- From: "Marten Lehmann" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, February 6, 2007 12:54:45 PM (GMT-0500) US/Eastern Subject: detecting the table type by sql? Hello, how can I get the type of a table (MyISAM, InnoDB, Berkeley DB) by a given table name with sql? Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
