Why not trying AMC Designor ? It manages these DBMSs and generates SQL
scripts for each.
b4U wrote:
> I am creating a designtool for databases which generetes.sql scripts for
> creation.
>
> Has anybody the SQL syntax for creating the following in
> Informix,
> Sybase,
> Progress,
> DB2,
> Ingres,
> xbase,
> rbase,
> access,
> paradox OR ANY OTHER DATABASE????
>
> Need syntax for creating The following items:
> tables + types and domains(if available).
> keys, foreign keys,
> constraints
> etc.
>
> Any examples will do.
> Please mention the database. with the scripts you sent.
>
> thanx a lot.
> Bas from The Netherlands