Sql

Search

Referential integrity constraint

The Referential integrity constraint is specified between
two relations and is used to maintain the consistency among
tuples in the two relations
//
– The referential integrity constraint states that a tuple(row) in
one relation that refers to another relation must refer to
an existing tuple(row) in that relation
//
For Example , If we want to delete a mother tuple(row) before deleting 
child tuple(row) which depend on mother current child primary key . 
Then it will show the Referntial integrity constraint error.

Comment

PREVIOUS	NEXT

Code Example
Sql :: space not removing from column in sql
Sql :: sql select most frequent value in column
Sql :: write sql query to find the second highest salary of employee
Sql :: does insert into overwrite sql
Sql :: delete all value query
Sql :: sql select duplicates based on two columns
Sql :: temp table vs variable table in sql server
Sql :: add primary key with auto increment to existing table column mysql
Sql :: update and replace mysql
Sql :: mysql delete table with foreign key
Sql :: postgres set null
Sql :: add a day big query
Sql :: get foreign table names mysql
Sql :: how to insert multiple rows in sql
Sql :: date format mysql
Sql :: mysql check date range
Sql :: python sqlite3 update
Sql :: oracle drop job if exists
Sql :: sql count unique values in one column
Sql :: Inner join - to join 3 tables - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-inner-join/
Sql :: with postgres
Sql :: sql select count distinct
Sql :: mysql to uppercase
Sql :: ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql
Sql :: postgres top 10
Sql :: mysql auerries to find the name starting with vowel letter
Sql :: q operator in plsql
Sql :: combine 2 columns search query mysql
Sql :: duplicate key value violates unique constraint in postgresql
Sql :: mysql count table rows

Search

SQL

Referential integrity constraint

ADD CONTENT