What is the difference between the Primary and Foreign key?
Answer Posted / dinesh kumar
Primary key will checks for the Duplicates.
Can hold only one primary key for a single table.
Foreign key will be referred from the Primary/unique Key
constraint. Hold even null values in it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
define join and explain different type of joins? : Sql dba
What is the size of partition table?
Why is sharding used?
How do you update a value in sql?
What will you get by the cursor attribute sql%rowcount?
What are the uses of sysdate and user keywords?
what is the stuff function and how does it differ from the replace function? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
What is a clob in sql?
What is write ahead logging in sql server?
List the various privileges that a user can grant to another user?
What are the different sql languages?
Which join is like inner join?
What are schema-level triggers?
Is subquery faster than join?