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

1 vote188 views3 answers
Read all columns of a table sql
SQL
1 vote187 views2 answers
Mysql select tables with name like
SQL
0 vote174 views1 answer
Initcap in sql
SQL
0 vote186 views1 answer
Postgres where
SQL
0 vote190 views1 answer
Mysql events not work
SQL
0 vote188 views1 answer
Flush user resource mysql
SQL
7 votes243 views4 answers
Mysql delete older duplicates
SQL
12 votes207 views6 answers
Change mysql root password
SQL
0 vote192 views1 answer
How to check replication lag in mySQL
SQL
0 vote349 views1 answer
Running mysql from bash sc
SQL