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.