I do not like "[OrderID] [int] NULL," in the [OrderDetail],

so you can insert orphan records despite the constraint.

CREATE TABLE [dbo].[OrderDetail]

(

[OrderDetailID] [int] NOT NULL,

[OrderID] [int] NULL,

CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED ([OrderDetailID] ASC)

)

The rest is basic!

😀