From: Martijn Tonies Date: August 3 2004 10:20am Subject: VIEWS and SHOW TABLE STATUS in MySQL 5.0.1 List-Archive: http://lists.mysql.com/mysql/170215 Message-Id: <043801c47943$7f6e6ed0$0a02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, Currently, a VIEW lists "NULL" as value for the "Engine" column in the SHOW TABLE STATUS resultset. Is this the right behaviour? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com