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 vote239 views1 answer
Oracle temporary table
SQL
1 vote172 views1 answer
Nested if in mysql
SQL
9 votes206 views1 answer
Alter table column change data type to text mysql
SQL
0 vote216 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote216 views1 answer
When mysql server would not work in xampp
SQL
0 vote196 views1 answer
Bitmap join index
SQL
1 vote238 views2 answers
Laravel jwt generate token
SQL
0 vote228 views3 answers
Java hide mysql login credentials
SQL
0 vote179 views1 answer
Mysql date minus 1 day
SQL
4 votes191 views2 answers
Postgre sql create table
SQL