| Subject | RE: [firebird-support] Re: How to delete firebird2 table field used as primary index? |
|---|---|
| Author | Nigel Weeks |
| Post date | 2006-11-13T04:33:22Z |
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.
---
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.