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 vote144 views1 answer
How to put is null in where in clause
SQL
0 vote142 views1 answer
Supprimer les valeur d'une table mysql
SQL
4 votes153 views3 answers
Is not null sql
SQL
0 vote133 views1 answer
Update top 100 sql
SQL
0 vote155 views1 answer
Postgresql inheritance
SQL
4 votes147 views5 answers
Primary key
SQL
0 vote144 views1 answer
Mysql select where field is a value
SQL
0 vote158 views1 answer
Mysql root localhost run
SQL
0 vote143 views1 answer
H2 auto increment and unique
SQL
0 vote150 views4 answers
Mysql replace regex
SQL