Get the last date the table structure was changed

[saint959]

Hey all,

 

Is there a way that i can get the date that a mysql table's structure was last changed?

 

I know i can get the last updated time but that only shows me when a record was entered into the table. I need to find when last the Structure was changed?

 

Any help would be hugely appreciated.

[The Little Guy]

$sql = mysql_query("SHOW TABLE STATUS where Name = 'table_name'");  // The where is optional, if not given it will show all tables
$row = mysql_fetch_assoc($sql);
echo $row['Update_time'];

[fenway]

Update_time isn't robust -- doesn't work on all platforms.