CREATE TABLE [dbo].[LineItems] (
    [OrderNumber] [int] NOT NULL ,
    [ProductID] [int] NOT NULL ,
    [UnitPrice] [money] NOT NULL ,
    [Quantity] [smallint] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Orders] (
    [OrderNumber] [int] IDENTITY (1001, 1) NOT NULL ,
    [OrderDate] [datetime] NULL ,
    [ShippedDate] [datetime] NULL ,
    [ShipName] [nvarchar] (40) NULL ,
    [ImportID] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Orders] WITH NOCHECK ADD
    CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED
    (
        [OrderNumber]
    )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[LineItems] ADD
    CONSTRAINT [FK_LineItems_Orders] FOREIGN KEY
    ([OrderNumber]
    ) REFERENCES [dbo].[Orders] (
        [OrderNumber])
GO