MS SQL Server QUery
Hi,
I am trying to run this query but keeps giving me an error on line 13, can anyone tell where the syntax issue is?
CREATE TABLE Degree_Classes
(DegreeClassID int NOT NULL,
ClassID INT,
DegreeID INT,
ClassCode VARCHAR(30),
ClassName VARCHAR(100),
Description TEXT,
CONSTRAINT DegreeClassID_PK
Primary KEY (DegreeClassID),
CONSTRAINT classID_FK
FOREIGN KEY (classID)
REFERENCES Classes(classID)
CONSTRAINT DegreeID_FK
FOREIGN KEY (DegreeID)
REFERENCES Degrees(DegreeID)
);
I am trying to run this query but keeps giving me an error on line 13, can anyone tell where the syntax issue is?
CREATE TABLE Degree_Classes
(DegreeClassID int NOT NULL,
ClassID INT,
DegreeID INT,
ClassCode VARCHAR(30),
ClassName VARCHAR(100),
Description TEXT,
CONSTRAINT DegreeClassID_PK
Primary KEY (DegreeClassID),
CONSTRAINT classID_FK
FOREIGN KEY (classID)
REFERENCES Classes(classID)
CONSTRAINT DegreeID_FK
FOREIGN KEY (DegreeID)
REFERENCES Degrees(DegreeID)
);
Who is Participating?
There is a comma missing. I tried this code and it is working:
But prior to executing this code, make sure ClassId in table Classes is a primary key.
The same goes with DegreeId in table Degrees.
I also doubt Degrees is a reserved word in SQL Server. Not sure.
CREATE TABLE Degree_Classes
(DegreeClassID int NOT NULL,
ClassID INT,
DegreeID INT,
ClassCode VARCHAR(30),
ClassName VARCHAR(100),
Description TEXT,
CONSTRAINT DegreeClassID_PK
Primary KEY (DegreeClassID),
CONSTRAINT classID_FK
FOREIGN KEY (classID)
REFERENCES Classes(classID),
CONSTRAINT DegreeID_FK
FOREIGN KEY (DegreeID)
REFERENCES Degrees(DegreeID)
);
But prior to executing this code, make sure ClassId in table Classes is a primary key.
The same goes with DegreeId in table Degrees.
I also doubt Degrees is a reserved word in SQL Server. Not sure.
Here is the error I get when trying to execute the query:
Msg 1769, Level 16, State 1, Line 1
Foreign key 'classID_FK' references invalid column 'classID' in referencing table 'Degree_Classes'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Let me know what you think
Msg 1769, Level 16, State 1, Line 1
Foreign key 'classID_FK' references invalid column 'classID' in referencing table 'Degree_Classes'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Let me know what you think
There is an implied sequence, those constraints won't work is the tables/fields being referenced do not exist
CONSTRAINT classID_FK
FOREIGN KEY (classID) -- << this field must exist, as primary key
REFERENCES Classes(classID), -- << in this table -- before this will work
CONSTRAINT DegreeID_FK
FOREIGN KEY (DegreeID) -- << this field must exist, as primary key
REFERENCES Degrees(DegreeID) -- << in this table -- before this will work
have you checked the tables: Classes & Degrees to see if those fields do exist?
The error message is pretty clear:
Foreign key 'classID_FK' references invalid column 'classID'
it is telling you that the field classID does not exist in table Classes
CONSTRAINT classID_FK
FOREIGN KEY (classID) -- << this field must exist, as primary key
REFERENCES Classes(classID), -- << in this table -- before this will work
CONSTRAINT DegreeID_FK
FOREIGN KEY (DegreeID) -- << this field must exist, as primary key
REFERENCES Degrees(DegreeID) -- << in this table -- before this will work
have you checked the tables: Classes & Degrees to see if those fields do exist?
The error message is pretty clear:
Foreign key 'classID_FK' references invalid column 'classID'
it is telling you that the field classID does not exist in table Classes
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month9 days, 16 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
As I wrote, first check:
(1) Do you have Classes table? If yes, make sure the ClassId column exists and it is a primary key.
(2) Do you have Degrees table? If yes, make sure the DegreeId column exists and is a primary key.
(3) Lastly, run the code I posted with comma correction.