I'm currently trying to work the following into my database
use MyShop;
CREATE TABLE Order(
Onr INT IDENTITY(1000,1)PRIMARY KEY,
TlfNr CHAR(8) FOREIGN KEY REFERENCES Kunde,
Odato DATETIME,
Vnr CHAR(10) FOREIGN KEY REFERENCES Varer, -- Varenummer
AnTal INT FOREIGN KEY REFERENCES Varer,
);
Yet I get an errormessage saying "Msg 156, Level 15, State 1, Line 3 - Incorrect syntax near the keyword 'Order'."
I've tried to see what the problem could be, but I havent been able to spot it, this is most likely easier than I'm making it. Maybe I might just be missing the most simple thing. I hope one of you wise men are able to help me with my problem.
View Complete Post