Query SELECT T.`TABLE_SCHEMA`, T.`TABLE_NAME`,T.`ENGINE`, T.`CREATE_TIME`, T.`UPDATE_TIME` FROM information_schema.`TABLES` T where TABLE_SCHEMA = 'TESTSCHEMA', Fri Aug 14 10:44:21 2009
TABLE_SCHEMA
TABLE_NAME
ENGINE
CREATE_TIME
UPDATE_TIME
TESTSCHEMA
T
IBMDB2I
1969-12-31 17:59:59
1969-12-31 17:59:59
TESTSCHEMA
TABLE001
IBMDB2I
1969-12-31 17:59:59
1969-12-31 17:59:59
TESTSCHEMA
t2
InnoDB
2009-08-13 17:10:39