Can anybody tell me the difference between a Primary key and
a Unique Key ?Kindly let me know the idea.Any help would be
highly appreciated.
firoz.raj -3 Posting Pro in Training
debasisdas 580 Posting Genius Featured Poster
Unique key enforces only uniqueness (no duplicate) where as a Primary key enforces both uniqueness and not null (data must be entered into the field). Once a PK is created on a column oracle creates an index on the column.
jbennet commented: good +22
firoz.raj -3 Posting Pro in Training
generally if i want primary key in ms access table.i just w.c on the
filed .and access create primary key.But how should i make Unique
Key in Ms Access table .Kindly let me know the idea.any help would
be highly appreciated.
debasisdas 580 Posting Genius Featured Poster
You need to change the field properties.
gana poduval 0 Newbie Poster
Bothe Primary key and unique constraints are using to uniquly identify the each record in the database.
The main Differnce are,.
1)There is only one primary key in one table but we can have multiple unique key in one table
2)We can have null value in Unique key column but we cannot have null value in primary key column.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.