|
Define primary key and foreign key.A column or combination of columns that identify a row of data in a table is Primary Key. A key in a table that identifies records in other table in called a foreign key.What is difference between UNIQUE and PRIMARY KEY constraints?A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. Primary Key doesn't allow NULL value whereas UNIQUE key allows NULL value.
|
