Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
6+9 =