且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将 varchar() 列限制为特定值?

更新时间:2023-01-19 20:57:59

您是否已经考虑在该列上添加一个 check constraint 来限制值?类似的东西:

Have you already looked at adding a check constraint on that column which would restrict values? Something like:

CREATE TABLE SomeTable
(
   Id int NOT NULL,
   Frequency varchar(200),
   CONSTRAINT chk_Frequency CHECK (Frequency IN ('Daily', 'Weekly', 'Monthly', 'Yearly'))
)