Mega Code Archive
Cascading Updates and Deletes
<![CDATA[
6> CREATE TABLE Orders (
7> OrderID int primary key ,
8> CustomerID nchar (5) NULL ,
9> EmployeeID int NULL ,
10> OrderDate datetime NULL ,
11> RequiredDate datetime NULL ,
12> ShippedDate datetime NULL ,
13> ShipVia int NULL ,
14> Freight money NULL DEFAULT (0),
15> ShipName nvarchar (40) NULL ,
16> ShipAddress nvarchar (60) NULL ,
17> ShipCity nvarchar (15) NULL ,
18> ShipRegion nvarchar (15) NULL ,
19> ShipPostalCode nvarchar (10) NULL ,
20> ShipCountry nvarchar (15) NULL
21> )
22> GO
1>
2>
3>
4> CREATE TABLE OrderDetails
5> (
6> OrderID int NOT NULL,
7> PartNo varchar(10) NOT NULL,
8> Description varchar(25) NOT NULL,
9> UnitPrice money NOT NULL,
10> Qty int NOT NULL,
11> CONSTRAINT PKOrderDetails
12> PRIMARY KEY (OrderID, PartNo),
13> CONSTRAINT FKOrderContainsDetails
14> FOREIGN KEY (OrderID)
15> REFERENCES Orders(OrderID)
16> ON UPDATE NO ACTION
17> ON DELETE CASCADE
18> )
19> GO
1>
2> drop table OrderDetails;
3> drop table Orders;
4> GO
]]>