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