Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 134991 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada and the answer
is mentioned below
Primary key: A Primary key is a column or group of columns
used to uniquely identify each row in a table like
It defines the column as a Mandatory column.
The data held across the column must be unique.
By default it creates clustered index.
It does not allow null values and duplicate values
Foreign key: A Foreign key is a column or group of columns
whose values are derived from the primary key of some other
table
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to export several tables together?
What happens to the current transaction if the session is ended?
How to define an external table with a text file?
what is the difference between restoring and recovering?
How to export your own schema?
How to update values in a table in oracle?
Is there a combination of "like" and "in" in sql?
How to write a left outer join with the where clause in oracle?
What are the uses of Database Trigger ?
Describe the types of sub query?
What are the differences between char and nchar in oracle?
How can we force the database to use the user specified rollback segment?
How to assign values to data fields in record variables?
How can windows applications connect to oracle servers?
How to use existing values in update statements using oracle?
