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 |
can a stored procedure call itself or recursive stored procedure? : Sql dba
write a query to find 4th max salary
How to process query result in pl/sql?
Which one is faster ienumerable or iqueryable?
What is a pdo connection?
Why do we create stored procedures & functions in pl/sql and how are they different?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
How do you take the union of two tables in sql?
Can we use threading in pl/sql?
Is sql pronounced sequel or sql?
what is column? : Sql dba
What is difference between cursor and ref cursor?
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)