Thanks Helen, I really appreciate the help!

Regards
Kelly


--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> 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
>