From: Martijn Tonies Date: March 7 2006 1:02pm Subject: Merge tables: how to know the base tables? List-Archive: http://lists.mysql.com/mysql/195478 Message-Id: <0d7e01c641e7$6d0e1c90$cd02a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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