List:General Discussion« Previous MessageNext Message »
From:Prasanna Raj Date:March 7 2006 1:12pm
Subject:Re: Merge tables: how to know the base tables?
View as plain text  
Hi 

Simple way is show table status; there is a column Type : value MRG_MyISAM is the base
table.

--Praj

On Tue, 7 Mar 2006 14:02:44 +0100
"Martijn Tonies" <m.tonies@stripped> wrote:

> Hi there,
> 
> How do you know what the sources are for a MERGE
> table?
> 
> SHOW TABLE STATUS doesn't show it, as far as I
> can see?
> 
> Is it really only available in SHOW CREATE TABLE?
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 
> 
Thread
Merge tables: how to know the base tables?Martijn Tonies7 Mar
  • Re: Merge tables: how to know the base tables?Prasanna Raj7 Mar
  • Re: Merge tables: how to know the base tables?Martijn Tonies7 Mar
    • Re: Merge tables: how to know the base tables?Prasanna Raj7 Mar