Information Schema shows deleted columns
Posted by: Tom Byars
Date: April 06, 2012 08:11AM

Hi, I'm using MySQL community server 5.01 & MySQL Query Browser 1.2.15 on windows vista. Any changes I make to a database are not being shown in the information schema.

e.g. if in the query browser I delete a column from a table then

SELECT COLUMN_NAME, TABLE_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name='MyTableName'
and table_schema = 'MyDB'

is still showing the deleted column for that table. The only way I've found to correct this is to reboot the computer. Anyone know a fix?

Options: ReplyQuote


Subject
Views
Written By
Posted
Information Schema shows deleted columns
6121
April 06, 2012 08:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.