SQL Server 2005 - Enumeration

rmatthew

Well-known member
Joined
Dec 30, 2002
Messages
115
Location
Texas
Is is possible to have an enumeration of valid values for a column/field?

For example -

If I needed a field that could only be one of:

Red
Green
Blue

without creating another table and limiting by using a foreign key.

Thanks in advance!
 
Back
Top