Jump to content

[SOLVED] Unique


LiamH

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/144783-solved-unique/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.