--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...> wrote:

>
> Fidel Viegas wrote:
> >> Both fields inside quotes. I tested again:
> >>
> >> CREATE TABLE "Demo" (
> >> "Codigo" INTEGER NOT NULL,
> >> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 8192,
> >> "Nombre" VARCHAR(50) NOT NULL COLLATE PXW_SPAN,
> >> "Observaciones" BLOB SUB_TYPE TEXT SEGMENT SIZE 4096
> >> );
>
> Where did you look and see this?
>
> Since this kind of situation should not be possible, my guess is that
> the tool you're using is reporting that those columns exist, while they
> do not. If you connect with isql at that point and issue:
>
> SHOW TABLE "Demo"
>
> what is the output?
>
>
> --
> Milan Babuskov
> http://www.flamerobin.org
> http://www.guacosoft.com
>

SHOW TABLE is a MySql command. The "equivalent" is:

SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0 AND RDB$VIEW_BLR IS NULL ORDER BY RDB$RELATION_NAME;

Table "Demo" IS listed in the result.