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" <lehmann@stripped>
To: mysql@stripped
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/mysql?unsub=1
