Subject | Re: How to delete firebird2 table field used as primary index? |
---|---|
Author | Adam |
Post date | 2006-11-13T05:00Z |
--- In firebird-support@yahoogroups.com, "Nigel Weeks" <nweeks@...>
wrote:
Adam
wrote:
>Hands up who else does that with cut and paste.
> 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.
>
Adam