Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in SQL Server only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
Forum
Topic
SQL Server
what is the difference between unique constraint and primarykey and identifiers
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
prasannas
New Member
Join Date:
Apr 2007
Posts:
1
#1
what is the difference between unique constraint and primarykey and identifiers
Apr 25 '07, 08:19 AM
what is the difference between unique constraint and primarykey and identifiers?
Paru
New Member
Join Date:
Jul 2007
Posts:
2
#2
Jul 4 '07, 05:31 AM
Unique key allows null values atleast one time but primary key never allows null entries.
Comment
Post
Cancel
debasisdas
Recognized Expert
Expert
Join Date:
Dec 2006
Posts:
8119
#3
Jul 4 '07, 10:43 AM
While a unique constraint enforces uniqueness (no duplicate value)
a primary key enforces not-null(value must be entered ) along with uniqueness.
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment