Tupy... nambá wrote:

> 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.

Without the picture it's a little difficult to comment, but I'd go for there
being a problem with the use or no of double quotes around the field name.
Either a reserved word which the designers automatically wrap, but then may not
be visible if the table's column was not defined with double quotes. Or
alternatively something case sensitive which would also need to be wrapped properly.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk