Explain primary key and foreign key constraints?



Explain primary key and foreign key constraints?..

Answer / Vikrant

Primary Key is a constraint used to ensure that each record in a table can be uniquely identified. It consists of one or more columns that contain unique values, and it enforces the uniqueness of those values.nnForeign Key is a constraint used to establish a relationship between two tables, where the foreign key in one table references the primary key of another table. It ensures referential integrity by preventing the deletion or modification of primary key values that have associated foreign key values.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How do I start sql server?

1 Answers  


How to delete the duplicate rows from a table in SQL Server ??

3 Answers  


What is meant by dirty read?

1 Answers  


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1 Answers  


what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  


What is row by row processing ?

2 Answers  


Difference between drill down and drill through report.

1 Answers  


What are rows and columns?

1 Answers  


How to get the definition of a user defined function back?

1 Answers  


Explain datetime2 data type in sal server 2008?

1 Answers  


What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,


Explain features and concepts of analysis services?

1 Answers  


Categories