What is the purpose of foreign key constraints?



What is the purpose of foreign key constraints?..

Answer / Shalendra Singh

"Foreign key constraints in PostgreSQL are used to enforce referential integrity between related tables. They help maintain data consistency by preventing the deletion or modification of records that would violate relationships defined within the database."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

What kind of database is postgres?

1 Answers  


Is postgresql good?

1 Answers  


How do you delete a column?

1 Answers  


Explain multi version concurrency control.

1 Answers  


How do I connect to a postgresql database remotely?

1 Answers  


Is postgresql a database?

1 Answers  


What is a foreign key example?

1 Answers  


State some of the advanced features of PostgreSQL?

1 Answers  


How to list the number of database?

1 Answers  


What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

1 Answers  


How many rows can postgres handle?

1 Answers  


How many columns can a postgres table have?

1 Answers  


Categories