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 vote277 views2 answers
Mysql calcular idade
SQL
0 vote276 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote245 views1 answer
What is the essence of SQL?
SQL
1 vote262 views2 answers
Login to mysql
SQL
1 vote271 views1 answer
Select count distinct multiple columns sql server
SQL
11 votes275 views1 answer
Oracle insert into where
SQL
1 vote262 views1 answer
Sqlite3 read only
SQL
0 vote251 views1 answer
Xampp mysql version
SQL
0 vote258 views1 answer
Replace multiple string in query sql
SQL
0 vote263 views1 answer
Load data from text file to mysql database on mac terminal
SQL