PDA

View Full Version : "You should define a primary key for this table" - I've already got one!


BigToque
02-14-2005, 07:03 AM
I've got a table that contains profile information of hockey players from my team.

when I use my select statement:


SELECT players.f_Name, players.l_Name, players.number, players.hand, players.height, players.weight, players.AKA,players.DOB, players.location, players.position, players.spare, players.imgURL
FROM players

It selects my data, but I get a question mark saying "You should define a primary key for this table". I've already got a primary key set.

What's going on?

Kiwi
02-14-2005, 10:01 AM
What was your CREATE statement for the table?