Subject Not visible columns
Author Tupy... nambá
Dear sirs,
 
I already had this problem and this happened to me once again.
 
I have a table whose columns are showed as not existing, at designers (as at EMS SQL Studio or ErWin) and also at the DDL comands for the table. But if you execute a SELECT command on it, it list all existing columns, and their data.
 
For your delight, I send pictures showing the situation.
 
Then, I ask for:
1.some explanation why this happens (may be, we can avoid this to be repeated later);
2.how to repair this situation, without removing and recreating this table.
 
Other indications about this will be welcome.
 
Thanks in advance,
Roberto Camargo,
Rio de Janeiro/Brazil

[Non-text portions of this message have been removed]