What is the difference between primary, unique and foreign key constraints, and indexes?

user_43907 0
Viewed 126788

What is the difference between primary, unique and foreign key constraints, and indexes?

I work on Oracle 10g and SQL Server 2008

indexing constraints oracle sql-server database
7 Answers

Primary key mainly prevent duplication and shows the uniqueness of columns Foreign key mainly shows relationship on two tables

user_92279170
Related