Good morning,
I am teaching myself SQL by reviewing articles and videos, etc..
One thing I have gotten stuck on is the CHECK Constraint.
I have a table, Jobs, where I am trying to verify that all start dates are BEFORE all end dates for each job.
This is what I have:
Code:
ALTER TABLE Jobs
ADD CONSTRAINT JobsCheckDates
CHECK (StartDate < EndDate);
But, every time I run it, Access pops up saying, Syntax error in CONSTRAINT CLAUSE. Then, it highlights CHECK on the third line.
I have tried researching what I am doing wrong, but I can't seem to figure it out. Perhaps I need to add a column, JobsCheckDates?
Could someone please help me out?
Thank you,
Aishlinn