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
Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Explain the concepts of relational data model? Relational Data Model - The relational model was first introduced through Prof. E.F. Codd of the IBM Research in the year 1970

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o

Explain the term- signal-to-noise ratio A signal-to-noise ratio of 20 dB means that S/N = 100. As log2101 is around 6.658, the Shannon limit is around 19.975 kbps. The Nyquist

What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.