> Looks like a bug in your database structure (or isql). Did you modify
> some system tables by hand?
>
> CHECK constraints are maintained by triggers but those should not be
> extracted as part of metadata script.
>
> Try extracting metadata with FlameRobin or some other tool and see if
> there is a difference.
>

I have extracted metadata with flamerobin, and the same problem. When i see ddl of a table with ibmanager or flamerobin, is displayed right, but when extrating metadata not. For example, this is ddl showed by flamerobin:

SYS_USUARIO_PRUEBA

Primary key
On field(s)

PK_SYS_USUARIO_PRUEBA
IDUSUARIO, IDPRUEBA
Add primary key

Foreign key
On field(s)
References
On update
On delete

FK_SYS_USUARIO_PRUEBA_1
IDUSUARIO
SYS_USUARIO
IDUSUARIO
RESTRICT
RESTRICT

FK_SYS_USUARIO_PRUEBA_2
IDPRUEBA
PRUEBA
IDPRUEBA
RESTRICT
RESTRICT
Add foreign key
Unique constraint
On field(s)
Add unique
Check constraint
Source

CHK_USUARIO_PRUEBA_MAYOR_0
check (IDUSUARIO > 0)

and when extrated metadata wit flamerobin look like this:

SET TERM ^ ;
CREATE TRIGGER CHECK_41 FOR SYS_USUARIO_PRUEBA ACTIVE
BEFORE UPDATE POSITION 0
check (IDUSUARIO > 0)^
SET TERM ; ^

> --
> Milan Babuskov
>
> ==================================
> The easiest way to import XML, CSV
> and textual files into Firebird:
> http://www.guacosoft.com/xmlwizard
> ==================================
>