Page 1 of 1

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
by answerhappygod
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?
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 1
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 1 (23.67 KiB) Viewed 41 times
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)