is more then one primary key in one table?

0 ⤊

is more then one primary key in one table?

as i know there be one primary key in one table.In any cases there be more then one primary key in one table.

2007-08-09 18:32:57 · 3 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design

3 answers

If you are asking about Access, then there can only be 1 primary key. That will be the way to establish relationships between the tables.

2007-08-09 18:38:23 · answer #1 · answered by Anonymous · 0⤊ 1⤋

There can only be 1 primary key. There can be many keys that can be used to access a record. Any one of those keys can have the unique property set to true, thereby making it act like a primary key.

2007-08-10 02:03:51 · answer #2 · answered by Dave H 4 · 0⤊ 0⤋

By definition, only one primary key exists in a table.

2007-08-10 01:35:31 · answer #3 · answered by mdigitale 7 · 0⤊ 2⤋