Home » SQL & PL/SQL » SQL & PL/SQL » How many Primary keys can a table have???
icon8.gif  How many Primary keys can a table have??? [message #264656] Tue, 04 September 2007 02:24 Go to next message
gogula77
Messages: 52
Registered: January 2006
Location: Hyderabad
Member

Hi all,

I have a question. How many Primary Keys can be there for a table?

As far as I know there can be one Primary key (either single or composite). But one of my friend is arguing that a table can contain more than one Primary Key.

Please give me your valuable suggestions.

Thanks

Gogula
Re: How many Primary keys can a table have??? [message #264659 is a reply to message #264656] Tue, 04 September 2007 02:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Only one. Your friend is wrong.
Re: How many Primary keys can a table have??? [message #264665 is a reply to message #264656] Tue, 04 September 2007 02:37 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...But there may be several UNIQUE keys.

Regards
Michel
Previous Topic: regarding dates
Next Topic: How to Combine data in a single SQL statement of two different clauses.
Goto Forum:
  


Current Time: Sat Dec 10 18:31:46 CST 2016

Total time taken to generate the page: 0.10140 seconds