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
Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.

Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t

The database depicted in the Visio diagram describes Proceeding , Article , Researcher , article PublishedIn a proceeding, article WrittenBy researchers and proceedings Edi

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

Build a database application for a sports league. Assume your application is to keep track of teams and equipment that is checked out to teams. Explain the steps that is needed and

Explain the concept of a data model ? Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the application

What are aggregate functions? And list the aggregate functions supported by SQL? Aggregate functions are functions that take a collection of values as input and return a one va

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. In par