SQL Server equivalent to MySQL enum data type?

Question

Whether the SQL Server 2008 has a data-type like the MySQL's enum?

Answer 1

It doesn't have one. However, there's a vague equivalent:

mycol VARCHAR(10) NOT NULL CHECK (mycol IN('Useful', 'Useless', 'Unknown'))

Are you interested to know SQL in detail? Come and join the Microsoft SQL Server Database certifications and training to gain more knowledge.

You can check out the below SQL Tutorial video for better understanding.