Answer Posted / vasant
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you inner join the same table?
What is a temp table?
What is difference between mysql and postgresql?
List and explain the different types of join clauses supported in ansi-standard sql?
what is sql profiler? : Sql dba
How do I run a program in pl sql?
What is pl sql quora?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Define commit, rollback and savepoint?
How to revise and re-run the last sql command?
How do I view a sql trace file?
How much does a sql dba make? : SQL DBA
how to add a new column to an existing table in mysql? : Sql dba
What are different functions in sql?