Monday, November 25, 2013

What is the difference between Primary Key & Unique index ?

Primary : a relational database constraint Primary key consists of one or more columns that uniquely identify a row in the table For a normalized relation, there is one designated primary key 
Unique index: a physical object that stores only unique values There can be one or more unique indexes on a table.

0 comments:

Post a Comment