Differentiate between Primary index & Primary Key in TD?

Primary Key

1. A relational concept used to determine relationships among entities and to define referential constraints.
2. Not required, unless referential integrity checks are to be performed
3. Define by CREATE TABLE statement

Primary Index:

1. Used to store rows on disk
2. Mandatory
3. Used to store rows on disk

Post a Comment