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
List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

what factors might influence a company to outsource its IT infrascture.

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons

basic structure of xml

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling. COURSE table contains following information:

Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.

Problem : AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions