Solved

Primary key Vs Unique key

Posted on 2004-09-09
2
4,976 Views
Last Modified: 2008-01-09
Is there any point in declaring a primary key if I already have a unique clustered index on the primary key field(s)?
0
Comment
Question by:billy21
2 Comments
 
LVL 5

Accepted Solution

by:
hkamal earned 350 total points
ID: 12018118
Yes, all tables should have a primary key
This just formalises your structure for inter-entity relationships
0
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12018444
I agree with hkamal that all tables should have a primary key. I've heard many reasons why people didn't define them for some tables, but I don't buy the arguments. It's a best practice and a good habit. If you define a primary key on a table and it actually never "needed", no harm is done. If you don't define a primary key because you're "sure" it will never be needed, but you turn out to be wrong, great harm can be done. And I've seen a great many databases that were in extremely bad shape because of failures including lack of primary keys where people didn't think they were needed.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
convert varchar UTC to human datetime 1 38
MSSQL join different row from other table 14 65
SQL Pivot table 2 42
SQL Consolidate rows 3 24
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question