Question: I am building a table in SQL and I am getting the error show below. Please advise as to what the correct syntax should be.Thank

I am building a table in SQL and I am getting the error show below. Please advise as to what the correct syntax should be.Thank you.

I am building a table in SQL and I am getting the

Create Table Create Table SALES OrderNumber varchar (20) PRIMARY KEY, StoreCode char(5) Not Null Foreign Key REFERENCES YourName-STORES OrderDate date Not Null, Quantity int Not Null, Terms varchar (12) Not N TitleID int Not Null, ul1 Messages Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'OrderDate

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!