Column constraints-on delete cascade, Database Management System

CREATE TABLE prodtrans

(

pno number (4)

ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5)

FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);

 

In the table so formed please reminder the referential constraint on the foreign key pno in prodtrans table to product table. Any product record if removed from the product table will trigger deletion of all the related records (ON DELETE CASCADE) in the prodtrans table.

 

Posted Date: 3/11/2013 12:56:08 AM | Location : United States







Related Discussions:- Column constraints-on delete cascade, Assignment Help, Ask Question on Column constraints-on delete cascade, Get Answer, Expert's Help, Column constraints-on delete cascade Discussions

Write discussion on Column constraints-on delete cascade
Your posts are moderated
Related Questions
Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

Prepare a data flow diagram for computing the volume and surface area of a cylinder. Inputs are the height and radius of the cylinder. Outputs are the volume and surface area of th

Describe association design of an object by giving one suitable example of it. The Design of Associations Associations are "glue" of advanced object oriented analysis and

While sorting, if the main storage available is not enough, the system writes data to an external help file.  The SAP profile parameter, which determines DIR_SORTTMP

waht is a repeating group?

What is DAG? The class-subclass relationship is shown by a directed acyclic graph.eg: employees can be temporary or permanent. We might be create subclasses temporary \and perm

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.

courier company er-diagram

First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat