CREATE TABLE EmpHiringInfo
employeeID int NOT NULL CONSTRAINT employeeid_fk REFERENCES Employee(employeeID) ON DELETE CASCADE,
gender char(1) CONSTRAINT gender_ck CHECK ('M', 'F'),
CONSTRAINT empid_fk_pk PRIMARY KEY(employeeID)
When i run the code, i get this error that points to gender's check constraint:
An expression of non-boolean type specified in a context where a condition is expected, near ','.