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


Please Help Members By Posting Answers For Below Questions

What is a mutating table error and how can you get around it?

549


Explain about service Broker functions?

623


What is a trigger in sql server?

547


What is dml command?

559


What are the limitations in ssrs on sql server express edition?

139






What encryption security is available in sql azure?

81


what's new in sql server 2016?

571


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

623


How to edit table in sql server 2017?

523


how can you check the level of fragmentation on a table? : Sql server administration

550


Explain log shipping?

597


What are the steps to insert a table?

549


What protocol does sql server use?

523


Explain the concept of view and Types of views in SQL server?

630


What happens if you add a new index to large table?

521