I have to create a table in Microsoft SQL Server, but I don't know how to check if "DaysOfWeek" field has the right valu
Posted: Thu May 05, 2022 1:35 pm
I have to create a table in Microsoft SQL Server, but I don't
know how to check if "DaysOfWeek" field has the right values like
("Monday","Tuesday"...). How could I create this constraint?
CREATE TABLE EPISODE (EpisodeID INT NOT NULL IDENTITY(1,1), Duration INT NOT NULL, Special Guest VARCHAR(50) NULL, DaysOfWeek TEXT NOT NULL EpisodeNo INT NOT NULL, Title VARCHAR(30) NOT NULL, Release Date DATE NOT NULL, ShowID INT NOT NULL, CONSTRAINT EPISODEFK FOREIGN KEY (ShowID) REFERENCES TV_SHOW (ShowID), CONSTRAINT EPISODEPK PRIMARY KEY (EpisodeID), CONSTRAINT EPISODEAK UNIQUE (EpisodeNo, Title)
know how to check if "DaysOfWeek" field has the right values like
("Monday","Tuesday"...). How could I create this constraint?
CREATE TABLE EPISODE (EpisodeID INT NOT NULL IDENTITY(1,1), Duration INT NOT NULL, Special Guest VARCHAR(50) NULL, DaysOfWeek TEXT NOT NULL EpisodeNo INT NOT NULL, Title VARCHAR(30) NOT NULL, Release Date DATE NOT NULL, ShowID INT NOT NULL, CONSTRAINT EPISODEFK FOREIGN KEY (ShowID) REFERENCES TV_SHOW (ShowID), CONSTRAINT EPISODEPK PRIMARY KEY (EpisodeID), CONSTRAINT EPISODEAK UNIQUE (EpisodeNo, Title)