Asked in Database ProgrammingSimilarities Between
What are the difference and similarities between primary key foreign key and unique key?
April 02, 2009 5:57AM
primary key: primary creates a clustered index on the
column and it doesn't allow null values.
unique key: unique key creates non clustered index by
default.it allows "one null value".
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables.
Fore More information, you can visit this website:http://www.iyogibusiness.com