Hi All,

FB 1.5 RC 7

I am using PowerDesigner as my modelling tool and generate the following CREATE TABLE ddl:

create table CDS_SYSTEM (
NAME VARCHAR(100) not null,
VALUE VARCHAR(100) not null,
constraint PK_CDS_SYSTEM primary key (NAME)
);

create unique asc index CDS_SYSTEM_PK on CDS_SYSTEM (
NAME
);

My question is since there is already a primary key, is the unique index still needed?

What is the benefit of having unique index since we already got a primary key in the table ?

Thanks.

cm


---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger

[Non-text portions of this message have been removed]