Create Tabel Problem

SQL Server Administration
1

Hello

I created the following CREATE TABLE Statement. but I can't execute it... Hier the error message "Incorrect syntax near the keyword 'LineNo'.". What is incorrect? The Definition for combined keys for MSQLServer is correkt1. Any ideas?

CREATE TABLE EventPlanLine (
PlanNo VARCHAR(8) NOT NULL,
LineNo VARCHAR(8) NOT NULL,
TimeStart DATE NOT NULL,
TimeEnd DATE NOT NULL,
NumberFLD INTEGER,
LocNo VARCHAR(8) NOT NULL,
ResNo VARCHAR(8) NOT NULL,
CONSTRAINT FK_EVENTPLAN FOREIGN KEY (PlanNo) REFERENCES EventPlan (PlanNo),
-CONSTRAINT PK_EVENTPLANLINE PRIMARY KEY (PlanNo, LineNo),
CONSTRAINT FK_LOCATION FOREIGN KEY (LocNo) REFERENCES Location (LocNo),
CONSTRAINT FK_ResourceTBL FOREIGN KEY (ResNo) REFERENCES ResourceTBL (ResNo),
CONSTRAINT EventStartAndEndTimeValidation CHECK (TimeStart < TimeEnd)
)

thanks

2

LineNo is a reserved word, so if you really need to use it put square brackets around it:

CREATE TABLE EventPlanLine (
PlanNo VARCHAR(8) NOT NULL,
[LineNo] VARCHAR(8) NOT NULL,
TimeStart DATE NOT NULL,
TimeEnd DATE NOT NULL,
NumberFLD INTEGER,
LocNo VARCHAR(8) NOT NULL,
ResNo VARCHAR(8) NOT NULL,
CONSTRAINT FK_EVENTPLAN FOREIGN KEY (PlanNo) REFERENCES EventPlan (PlanNo),
CONSTRAINT PK_EVENTPLANLINE PRIMARY KEY (PlanNo, [LineNo]),
CONSTRAINT FK_LOCATION FOREIGN KEY (LocNo) REFERENCES Location (LocNo),
CONSTRAINT FK_ResourceTBL FOREIGN KEY (ResNo) REFERENCES ResourceTBL (ResNo),
CONSTRAINT EventStartAndEndTimeValidation CHECK (TimeStart < TimeEnd)
)