Subject Re: How to delete firebird2 table field used as primary index?
Author Adam
--- In firebird-support@yahoogroups.com, "Nigel Weeks" <nweeks@...>
wrote:
>
> An example of use would be:
>
> ---
>
> CREATE GENERATOR GEN_EMPLOYEEID;
>
> CREATE TABLE EMPLOYEE
> (
> EMPLOYEEID BIGINT,
> FIRSTNAME VARCHAR(50),
> LASTNAME VARCHAR(50),
> DOB DATE,
> TAXFILENUMBER VARCHAR(30),
> CONSTRAINT PK_EMPLOYEE PRIMARY KEY (UID)
> );
>
>
> Presumably you meant:
>
> CONSTRAINT PK_EMPLOYEE PRIMARY KEY (EmployeeID)
>
> Nige.
>

Hands up who else does that with cut and paste.

Adam