将 varchar() 列限制为特定值? [英] Restrict varchar() column to specific values?

问题描述

有没有办法为 MS SQL Server 2008 中的 varchar 列指定例如 4 个不同的值?

Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008?

例如，我需要一个名为 Frequency (varchar) 的列，它只接受Daily"、Weekly"、Monthly"、Yearly"作为可能的值

For example, I need a column called Frequency (varchar) that only accepts 'Daily', 'Weekly', 'Monthly', 'Yearly' as possible values

是否可以在创建表时在 SQL Server Management Studio 中进行设置?

Is this possible to set within the SQL Server Management Studio when creating the table?

推荐答案

您是否已经考虑在该列上添加一个 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'))
)

这篇关于将 varchar() 列限制为特定值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！