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 triggers long term care?
How to configure odbc dsn with different port numbers?
Can we install sql server 2016 on windows 7?
What is application role in sql server database security? : sql server security
Can we insert data into view sql server?
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
Can we linked SharePoint to a SQL database?
What are trace flags?
What is dimension table? : sql server analysis services, ssas
Explain microsoft sql server functions?
What does ss stand for sexually?
What is the optimization being performed in oracle and SQL Server?
What is b tree index?
Why do we use trigger?
You want to implement the one-to-many relationship while designing tables. How would you do it?