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 vote200 views1 answer
Python mysql query to dataframe
SQL
0 vote190 views2 answers
Start mysql server using docker
SQL
0 vote207 views1 answer
Dataframe lambda elif
SQL
1 vote193 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote224 views1 answer
Mysql wait_timeout
SQL
6 votes185 views1 answer
Phpmyadmin reset root password
SQL
0 vote188 views1 answer
Back up stored procedures mysql
SQL
0 vote183 views2 answers
Sql select inside select
SQL
5 votes188 views1 answer
Oracle ORA-00054 origin
SQL
0 vote184 views1 answer
Vowels in sql
SQL