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
>
>