Wrong info from Information_schema

[Tom Byars]

I deleted a column from table Tbl a few weeks back and then reinserted it a week ago. When I run this query

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='Tbl';

the deleted/reinserted column is missing.

I created a new table with

create table NewTbl select * from Tbl;

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='NewTbl';

did show the column in question but when I renamed Tbl to Tbl2 and then NewTbl to Tbl the query

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='Tbl';

did not show the column in question yet the query

select group_concat(column_name) from information_schema.columns where table_schema='dbase' and table_name='NewTbl';

did show the column even though the dbase schema no longer contained a table called NewTbl.

Can anyone cast any light on this? I'm using MySQL community 5.1.