Question: Create Table Order ( OrderID Int NOT NULL Identity (1,1), StoreID Int NOT NULL, CustomerID Int NOT NULL, ProductID Int NOT NULL, OrderDate Date NOT
Create Table Order ( OrderID Int NOT NULL Identity (1,1), StoreID Int NOT NULL, CustomerID Int NOT NULL, ProductID Int NOT NULL, OrderDate Date NOT NULL, Quantity Int NULL, Price Numeric (9,2) NOT NULL, PaidFor Char (1) NULL, OrderStatus Char (10) NULL, Constraint OrderPK Primary Key (OrderID), Constraint StoreFK Foreign Key (StoreID), References Location (StoreID) On Update No Action On Delete No Action, Constraint CustomerFK Foreign Key (CustomerID) References Customer (CustomerID) On Update No Action On Delete No Action, Constraint ProductFK Foreign Key (ProductID) References Product (ProductID) On Update No Action On Delete No Action );
Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'Order'. Msg 102, Level 15, State 1, Line 15 Incorrect syntax near 'Action'. Msg 102, Level 15, State 1, Line 19 Incorrect syntax near 'Action'. Msg 102, Level 15, State 1, Line 23 Incorrect syntax near 'Action'.
How do I fix my query?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
