SQL Server equivalent to MySQL enum data type?

user_155758 0
Viewed 166560

Does SQL Server 2008 have a a data-type like MySQL's enum?

sql-server-2008 tsql sql-server sql types
5 Answers

You can try something like

ALTER TABLE dbo.yourTable
ADD CONSTRAINT yourColumn CHECK(yourColumn IN('XL','L','M','S','XS'))
user_75846000
Related