Enum in SQL Server

USE WorldofWarcraft;

CREATE TABLE [users]
(
   ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
   username nvarchar(255),
   password nvarchar(255),
   mail nvarchar (255),
   [rank]  nvarchar (255) NOT NULL CHECK ([rank] IN('Fresh meat', 'Intern','Janitor','Lieutenant','Supreme being')) DEFAULT 'Fresh meat'
);

Source: stackoverflow.com

Similar codes

0 vote318 views1 answer
Plsql trigger insert update
SQL
0 vote353 views1 answer
Get foreign table names mysql
SQL
1 vote332 views4 answers
Fatal database postgres does not exist
SQL
0 vote367 views1 answer
Psql list rules
SQL
23 votes364 views3 answers
Sql where contains part of string
SQL
0 vote326 views1 answer
Oracle create package body
SQL
0 vote393 views1 answer
Add user mysql wordpress
SQL
0 vote384 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
5 votes334 views4 answers
Describe table postgres
SQL
1 vote336 views1 answer
Add sequence postgres
SQL