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" <[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? > > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]