CASCADE ex in SQL server!

CREATE TABLE [dbo].[Products](

[ProductID] [int] NOT NULL,

[ProductDesc] [varchar](50) NOT NULL,

CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED

(

[ProductID] ASC

)) ON [PRIMARY]

CREATE TABLE [dbo].[ProductDetails](

[ProductDetailID] [int] NOT NULL,

[ProductID] [int] NOT NULL,

[Total] [int] NOT NULL,

CONSTRAINT [PK_ProductDetails] PRIMARY KEY CLUSTERED

(

[ProductDetailID] ASC

)) ON [PRIMARY]

GO

ALTER TABLE [dbo].[ProductDetails] WITH CHECK ADD CONSTRAINT

[FK_ProductDetails_Products] FOREIGN KEY([ProductID])

REFERENCES [dbo].[Products] ([ProductID])

ON UPDATE CASCADE

ON DELETE CASCADE

INSERT INTO Products (ProductID, ProductDesc)

SELECT 1, 'Bike'

UNION ALL

SELECT 2, 'Car'

UNION ALL

SELECT 3, 'Books'

INSERT INTO ProductDetails

([ProductDetailID],[ProductID],[Total])

SELECT 1, 1, 200

UNION ALL

SELECT 2, 1, 100

UNION ALL

SELECT 3, 1, 111

UNION ALL

SELECT 4, 2, 200

UNION ALL

SELECT 5, 3, 100

UNION ALL

SELECT 6, 3, 100

UNION ALL

SELECT 7, 3, 200

SELECT *

FROM Products

SELECT *

FROM ProductDetails

DELETE

FROM Products

WHERE ProductID = 1

select * from dbo.ProductDetails

select * from dbo.Products

DROP TABLE ProductDetails

DROP TABLE Products