Subject Re: [Firebird-Architect] autoincrement fields
Author Ann W. Harrison
paulruizendaal wrote:
...
>
> CREATE TABLE person ( id SERIAL, name TEXT );
>
> is automatically translated into this:
>
> CREATE SEQUENCE person_id_seq;
> CREATE TABLE person (
> id INT4 NOT NULL DEFAULT nextval('person_id_seq'),
> name TEXT );
>
> Would there be any issues with doing the same for Firebird?

Just the usual problem of name lengths in the creation of the
generator, but we could just use some sort of automatic name
generation...


Regards,


Ann