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 triggers long term care?

718


How to configure odbc dsn with different port numbers?

756


Can we install sql server 2016 on windows 7?

867


What is application role in sql server database security? : sql server security

756


Can we insert data into view sql server?

722






you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

731


Can we linked SharePoint to a SQL database?

749


What are trace flags?

767


What is dimension table? : sql server analysis services, ssas

747


Explain microsoft sql server functions?

767


What does ss stand for sexually?

796


What is the optimization being performed in oracle and SQL Server?

803


What is b tree index?

678


Why do we use trigger?

712


You want to implement the one-to-many relationship while designing tables. How would you do it?

709