Subject Re: [firebird-support] Re: FB 1.5 to 2.1 question
Author Helen Borrie
At 02:59 13/09/2008, you wrote:

>As for primary keys...my table create is:
>
>
>/* Table: OWNERS */
>CREATE TABLE OWNERS (
> OWNERNAME VARCHAR(50),
> NOTES BLOB SUB_TYPE 1 SEGMENT SIZE 4096,
> UNIQUEKEY VARCHAR(20) NOT NULL,
> CREATEDATE VARCHAR(10),
> EDITDATE VARCHAR(10),
>(etc)
> RECPOSTEDBY VARCHAR(20),
> CONSTRAINT PK_OWNERS PRIMARY KEY (UNIQUEKEY)
>);
>
>CREATE INDEX AK_OWNERSOWNER ON OWNERS(OWNERNAME);
>
>
>Is this valid and proper for FB2.1? Is this what you meant
>by "putting a primary key on the table"?

Yes and Yes.

./heLen