[SOLVED] Unique

[LiamH]

Hi all,

 

I have something I just wanted to check with you. I have the following bit of code below;

 

CREATE TABLE tblCategory(
CategoryID INT UNIQUE NOT NULL,
CategoryName VARCHAR(25) NOT NULL,
PRIMARY KEY (CategoryID)
);

 

As you can see I have the PK CategoryID, which I have also stated needs to be unique. I'm just wondering whether I need to have the Unique part in, seen as I already have this field as a PK. I have a feeling that I don't need it, but just thought i'd check.

 

Thanks all

[rhodesa]

no, you don't need UNIQUE...PRIMARY KEY makes the field unique

[LiamH]

That's what I thought. Thanks a lot