I have this table but check constraint is throwing me an error:
Column CHECK constraint for column 'MedicamentRegulated' references another column, table 'Medicaments'.
I've seen this as allowed in SQL Server but I don't know why it doesn't work :/
CREATE TABLE Medicaments (
MedicamentID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
Name VARCHAR(50),
DateValidity DATE,
MedicamentRegulated BIT CHECK((MedicamentRegulated = 1 AND DateValidity IS NOT NULL)
OR MedicamentRegulated = 0)
)