What is Referential Integrity?
Answers were Sorted based on User's Feedback
Answer / suriyaraj
Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept
of referential integrity states that you may not add a
record to the table that contains the foreign key unless
there is a corresponding record in the linked table. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rajeshwaran
It is a rule defined on a column or a set of columns that
allows to insert or update a value in a table that matches
with the values in the corresponding columns of the related
tabels.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / dhirendra
Referential Integrity means: Whenever parent values are
available, the user can not transact it to Transaction table.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is percent sign in sql?
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
What is correlated sub-query?
How many types of indexes are there in sql?
how to create a database in oracle?please gve anser with example
how do you count the duplicate records in a table
What are sql indexes?
Who is the owner of mysql database?
What is consistency?
What port does sql server use?
What is the purpose of the primary key?
How to create a view on a table which does not exists
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)