Primary Key
1) There can be only one Primary key in a table.
2) Primary key creates Cluster Index
3) Primary key provide two constraint inforceness "UNIQUE + NOT NULL"
4) We can reference Primary Key for Foreign Key constraint.
Unique Key
1) More than one Unique key can be created in a table
2) Unique Key creates Non-Clustered Index
3) Unique Key provides only "Uniqueness for Table"
4) We can reference Unique Key for Foreign Key constraint.
Showing posts with label Difference between PRIMARY KEY and UNIQUE KEY. Show all posts
Showing posts with label Difference between PRIMARY KEY and UNIQUE KEY. Show all posts
Monday, July 14, 2008
Subscribe to:
Posts (Atom)