Hi, > Simple way is show table status; there is a column Type : value MRG_MyISAM is the base table.
No, that's not what I meant -- I meant, the merge table uses a UNION clause to get signal where it get it's data from. Where can I get the sources for the merge table? That is, what is used in the UNION clause when creating it. 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 > --Praj > > On Tue, 7 Mar 2006 14:02:44 +0100 > "Martijn Tonies" <[EMAIL PROTECTED]> 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]