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 vote141 views1 answer
Search from comma separated values in sql server
SQL
1 vote143 views1 answer
Get table which have specific columns in mysql
SQL
4 votes192 views2 answers
Mysql alter table set column unique
SQL
0 vote140 views1 answer
Char varchar nvarchar sql
SQL
1 vote183 views2 answers
Sql split string by space
SQL
0 vote155 views2 answers
Dbms interview questions
SQL
0 vote143 views1 answer
Denormalise SQL command
SQL
8 votes188 views3 answers
Postgres database sizes
SQL
0 vote150 views1 answer
Mssql disable foreign key constraint
SQL
0 vote173 views1 answer
Login failed for user sql server
SQL