Multiple Primary Key in SQL Server2005

Question

hello guys how r u ?

my question is that, can we keep more then one primary key in a single table in sql server2005? if yes then kindly tell me how ? and if no then kindly tell me the reason?

Reply Soon

Thanks.

Sam Hobbs · Answer

A Primary Key is called Primary for a reason; by definition of primary there is only one of them.

Suthish Nair · Answer

Thumps Up, for Sam ! But Faisal, you can create Identity Key column also. http://www.c-sharpcorner.com/Forums/Thread/125873/sql-server-fun-4-how-to-insert-duplicate-values-to-iden.aspx

Tulasi · Answer

Hi, Primary Key : We cannot create multiple primary key on single table. Primary Key enforces uniqueness of the column on which they are defined. Primary Key creates a clustered index on the column. Primary Key does not allow Nulls. When you define more t han one column as your primary key on a table, it is called a composite primary key. Note : we can create only one Clustered Index on table have a look at this http://weblogs.sqlteam.com/jeffs/archive/2007/08/23/composite_primary_keys.aspx Please mark the answer as Accepted if it helps you.

Faisal Ansari · Answer

Thanks to you all Friends :) i got my answer ... Thanks 4 reply

Multiple Primary Key in SQL Server2005

Answers (4)