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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!