-
How many ways you can delete the table records ?
In how many ways can I delete all the contents of a table and the entire table. Explain with syntax ?
ranadhee_85
- Feb 9th, 2011
we delete record in a table 2 ways 1.by using delete command syntax:delet from table name where condition. example:delete from emp where en...
mukesh chand yadav
- Dec 7th, 2010
There are two(2) ways to delete recordes from a table are as follows: 1. Delete a specific record from table. ...
-
-
What is referential integrity constraint
Read Best Answer
Editorial / Best Answer
Shivani Goel- Member Since Jun-2009 | Jun 23rd, 2009
Referential integrity constraint is that which depend upon the parent and child relationship. In this one of the column have the primary key constraint and one of the column of another table have the foreign key constraint. So you cannot delete the column value which having the foreign key constraint until you never delete its related primary key column value from parent table. If you tried to do this it will show you error related to referential integrity constraint. But if you still want to delete value from child table but never want to delete parent table column value then that purpose you can use 'on delete cascade' option.
kierthi
- Aug 16th, 2011
A feature provided by relational database management systems (RDBMS's) that prevents users or applications from entering inconsistent data. Most RDBMS's have various referential integrity rules that y...
Shivani Goel
- Jun 23rd, 2009
Referential integrity constraint is that which depend upon the parent and child relationship. In this one of the column have the primary key constraint and one of the column of another table h...
-
What is an integrity constraint
Read Best Answer
Editorial / Best Answer
Shivani Goel- Member Since Jun-2009 | Jun 23rd, 2009
Integrity constraint is that which depend upon the parent and child relationship in which parent column have the primary constraint and child column have the foreign key constraint.
You cannot delete the any value from column that have foreign key constraint until you never delete its related primary key column value, that is a integrity constraint.
If you try to do this it will show you error related to integrity constraint.Shivani Goel
- Jun 23rd, 2009
Integrity constraint is that which depend upon the parent and child relationship in which parent column have the primary constraint and child column have the foreign key constraint. You cannot d...
Rossitza Kanovska
- Aug 9th, 2005
An integrity constraint is a rule that restricts the values in a database. There are six types: A NOT NULL constraint prohibits a database value from being null. A unique constraint prohibi...
