Re: [SQL] Creating table with unique key.

>
> At 2:49 PM 8/5/98, Colin Dick wrote:
> >> > CREATE TABLE cliente (
> >> >         name    varchar(100) UNIQUE NOT NULL,
> >> >         username        varchar(8) NOT NULL ,
> >> >         key     int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
>
> There should be no comma (,) in the last field description.
>
> >> >         );
> >
> >Hi this is from a previous post regarding auto-incrementing.  I have that
> >part working, now I am trying to create a table with a field which will
> >not be null and will be unique to the rest of table.  Is this possible and
> >what is the correct syntax.  I have tried and receeved the following:
> >
>
> CREATE TABLE cust (
>   FileNumber int4 unique not null,
>   CompName varchar(50),
>   FirstName varchar(50),
>   LastName varchar(50),
>   BirthDate varchar(8),
>   Suite varchar(5),
>   Address varchar(50),
>   City varchar(20),
>   Province varchar(20),
>   PostalCode varchar(7),
>   Email varchar(50),
>   HomePhone varchar(14),
>   WorkPhone varchar(14),
>   FaxPhone varchar(14));

I use the UNIQUE keyword on an index to force a uniqueness in a table field.

eg.

create unique index pindex_id
on product using btree (product_id);


Where the field product_id is defined in the table as being not allowing a
null value.  This works like a charm....

-=pierre