What is Primary key and foreign key? Give an example
Answer Posted / vipin
Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What protocol does sql server use?
What is the default sql server instance name?
What are types of subqueries?
What are the elements of dbms?
What happens when transaction log is full?
How would you use user_constraints table in DB?
How to name query output columns in ms sql server?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is Cross Join and in which scenario do we use Cross Join?
what is the system function to get current user's user id? : Sql server database administration
What is use of dbcc commands?
What is mean by candidate key?
Can we call future method from trigger?
You want to implement the one-to-many relationship while designing tables. How would you do it?
what is raid? : Sql server database administration