<p>I'm working on a project and I want to store some easily enumerated information in a table.  MySql's enum data type does exactly what I want: <a href="http://dev.mysql.com/doc/refman/5.0/en/enum.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.0/en/enum.html</a> .  Is there an equivalent in SQL Server 2005?</p>

<p>I know I could store the possible values in a type table with a key, but I'd rather not have to link back to it for descriptions.  Our database standards don't allow us to link on non-integer or uniqueidentifier fields, so storing the possible keys as characters is out as well.</p>

Does this work for you?
From
http://blechie.com/wtilton/archive/2007/08/24/303.aspx
Create table...
MySQL:
```
```
ColumnName ENUM('upload', 'open', 'close', 'delete', 'edit', 'add')
   DEFAULT 'open'
```
```
SQL Server:
```
```
ColumnName varchar(10) 
   CHECK(ColumnName IN ('upload', 'open', 'close', 'delete', 'edit', 'add')) 
   DEFAULT 'open'
```
```