List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:February 6 2007 6:18pm
Subject:Re: detecting the table type by sql?
View as plain text  
 >how can I get the type of a table (MyISAM, InnoDB, Berkeley DB)
 >by a given table name with sql?

select engine
from information_schema.tables
where table_schema='dbname' and table_name='tblname';

PB

Marten Lehmann wrote:
> Hello,
>
> how can I get the type of a table (MyISAM, InnoDB, Berkeley DB) by a 
> given table name with sql?
>
> Regards
> Marten
>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.411 / Virus Database: 268.17.28/672 - Release Date: 2/6/2007

Thread
detecting the table type by sql?Marten Lehmann6 Feb
  • Re: detecting the table type by sql?Peter Brawley6 Feb
  • Re: detecting the table type by sql?Philip Mather6 Feb
  • Re: detecting the table type by sql?Philip Mather6 Feb
  • Re: detecting the table type by sql?Rolando Edwards6 Feb