Question: 5. Define the affect the ON DELETE CASCADE statement has as shown below. (5 points) CREATE TABLE LINE ( INV_NUMBER LINE NUMBER P CODE
5. Define the affect the "ON DELETE CASCADE" statement has as shown below. (5 points) CREATE TABLE LINE ( INV_NUMBER LINE NUMBER P CODE INTEGER NOT NULL, NUMERIC(2,0) NOT NULL, VARCHAR(10) NOT NULL, LINE UNITS NUMERIC (9,2) DEFAULT 0.00 NOT NULL, LINE PRICE NUMERIC(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV NUMBER,LINE NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE (INV_NUMBER) ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE));
Step by Step Solution
3.39 Rating (155 Votes )
There are 3 Steps involved in it
The SQL code you provided creates a table named LINE In this table there are several columns defined ... View full answer
Get step-by-step solutions from verified subject matter experts
