TAG:
|
CREATE TABLE Statement for the NewOrders Table 1: CREATE TABLE NewOrders(OrderNumber INTEGER, 2: OrderDate DATETIME, CustomerNumber INTEGER, 3: PaymentMethod VARCHAR(50)) The Primary Key Constraint for the NewOrders Table 1: ALTER TABLE NewOrders 2: ADD CONSTRAINT OrderNumberIndex 3: PRIMARY KEY (ordernumber) The Foreign Key Constraint Between the ProductsPurchased and NewOrders Tables 1: ALTER TABLE ProductsPurchased 2: ADD CONSTRAINT fk_ordernumber 3: FOREIGN KEY (OrderNumber) 4: REFERENCES NewOrders (OrderNumber) (jacky) |